DSXchange

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

Brian was right! There is GetEnvironment in Utility will help you get the value of any environment variable. Go to Utility ->GetEnvironment in derivation editor, and provide the syntax like GetEnvironment("APT_CONFIG_FILE") will do the trick for you... My previous method will also do this...

Welcome Aboard ! I have a couple of questions for you - What is the error you are getting? - How have you given reference to the Environment variables? I defined the environment variable as a job parameter. In the transformer while doing the mapping for the field 'LST_UPDT_ID' i am mapping its valu...

I defined the environment variable as a job parameter. In the transformer while doing the mapping for the field 'LST_UPDT_ID' i am mapping its value as $APT_ORACLE_LOAD_OPTIONS. While compiling its gives the following compilation error. The problem doesn't arise if i give a normal job parameter inst...

Hi, I am trying to assign the value of an environment variable to a column in a parallel transformer stage. I had defined the env variable as a job parameter and selected the same as the value for the column in the Xform stage. When i try to compile the PX job its giving an error. Any help towards r...