datastage command for environment variable

Merly · Post by **Merly** » Thu Aug 02, 2007 3:51 pm

Is there any datastage command which can be used to get the value of the environment variable .

ArndW · Post by **ArndW** » Thu Aug 02, 2007 3:59 pm

Yes, there is. But it depends upon where you wish to get this value. I can't recall the exact function name that you can use in a transform stage, but you will get it shown to you in the drop-down list of functions. You can also shell out to UNIX in many places and retrieve the value there.

Luciana · Post by **Luciana** » Thu Aug 02, 2007 4:45 pm

Hi,

Can be used the function GetEnvironment(%envvar%) in the transformer stage.

Code: Select all

GetEnvironment('APT_CONFIG_FILE')