How to use an Environment Variable into Userdefine routine

ArijitS · Post by **ArijitS** » Mon Nov 05, 2007 3:53 am

Is it possible to use an Environment Variable into any User Define Datastage routine.If so then please help me by a piece of code as an example.

JoshGeorge · Post by **JoshGeorge** » Mon Nov 05, 2007 6:58 am

If you have a job attached inside the routine:

Code: Select all

DSGetParamInfo(hJob1, "$VarName", DSJ.PARAMDEFAULT) 
where hJobName is the job attached using DSAttachJob

chulett · Post by **chulett** » Mon Nov 05, 2007 7:16 am

Or, if not, a simple call to your O/S to 'echo' it and capture the results can be used.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 05, 2007 7:29 am

There is also the "UniVerse" command ENV (that you might execute using DSExecute subroutine), which will return all environment variables, and you could process that string with FINDSTR to locate the one(s) in which you're interested.

roy · Post by **roy** » Tue Nov 06, 2007 2:29 am

How about running the job and assigning that environment variable as a parameter to it?