calling routine within a routine

[dsx_newbie]

Hi to all datastage gurus,

How do you call a routine within a routine in datastage? I am creating a custom routine and wants to use the UtilityHashLookup routine inside my custom routine.

I tried the syntax "Call DSX.UtilityHashLookup("HA_REC_TYPE","2000",2)" but when i compile it's telling me that the routine is expecting 4 arguments but it only has 3 arguments.

Is there any other way to call the subroutine?

[kcbland]

It's not CALL'ed like a subroutine. Search the forum for DEFFUN to see examples.

[ray.wurlod]

One of the strange things about functions in DataStage BASIC is that they can, indeed, be called as subroutines; the first argument position is reserved for the return value. Therefore the following are equivalent.

Code: Select all

Call DSX.UTILITYHASHLOOKUP(Result,"HA_REC_TYPE","2000",2)

Code: Select all

DEFFUN UtilityHashLookup(Arg1,Arg2,Arg3) Calling "DSX.UTILITYHASHLOOKUP"

Result = UtilityHashLookup("HA_REC_TYPE","2000",2)

[DSguru2B]

Code: Select all

Call DSX.UTILITYHASHLOOKUP(Result,"HA_REC_TYPE","2000",2)

Hmm. I didnt know a subroutine could be called like that. Thanks for the info Ray.

[ray.wurlod]

I trust that everyone noticed that SDK routines are catalogued with a "DSX." prefix (rather than "DSU.") and that the catalog name is all upper case.

[DSguru2B]

What if I want to call a userdefined routine. Can i use the same format with DSU. instead of DSX. ?

[chulett]

Yup.

[DSguru2B]

Cool