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)
Why is it so? Is it because the datastage environment variables will be loaded into memory, only when it is called from a job?