Accessing Datastage Env variable value in Basic Rouitne

[dstest]

Hi,

Can any one please tell me how to access datastage Env variable value in basic routine.

Thanks

[rameshrr3]

You can use a code snippet similar if you have a job handle attached.

Code: Select all

CurrentJobHandle = DSJ.ME 
/* CurrentJobHandle= DSAttachJob(JobName,DSJ.ERRFATAL)*/
TargetEnv =  '$TARGET_ENV'
TargetEnvValue = DSGetParamInfo(CurrentJobHandle, TargetEnv, DSJ.PARAMVALUE)
Ans = TargetEnvValue

In the example above $TARGET_ENV is a parameter defined as a DS Environment variable.

[umamahes]

I know this way.I am asking is there any other way with out adding env in the job parameter can we access env value in basic routine

[ray.wurlod]

Code: Select all

FUNCTION GetEnvironmentVariable(EnvVarName)
      If UnAssigned(EnvVarName) Or IsNull(EnvVarName)
      Then
         Ans = @NULL
      End
      Else
         Call DSExecute("UV", "ENV", Output, ExitStatus)
         FindStr EnvVarName In Output Setting FMC,VMC,SMC
         Then
            Ans = Field(Output<FMC,VMC,SMC>, "=", 2, 99)
         End
         Else
            Ans = ""
         End
      End
RETURN(Ans)

[vivekgadwal]

I have a question with this routine Ray.

> Is there a reason why "UnAssigned()" is present twice?

Code: Select all

If UnAssigned(EnvVarName) Or UnAssigned(EnvVarName) 
      Then 
         Ans = @NULL

[kcbland]

Code: Select all

UNIXcmd="echo $yourenvironmentvariable"
CALL DSExecute("UNIX", UNIXcmd, ScreenOutput,ReturnCode)
yourenvironmentvariable = ScreenOutput<1>

[ray.wurlod]

The test condition should have been

Code: Select all

UnAssigned(EnvVarName) Or IsNull(EnvVarName)

I have edited the original post to show this.