Page 1 of 1

Change/Modify the DS Environmental variable value

Posted: Wed Aug 17, 2011 2:22 am
by Murali4u
I have a requirement, i need to change the value of the existing environmental variable after the completion of job execution.? Can anyone pls tell us the solution if you have cme across.

Posted: Wed Aug 17, 2011 2:42 am
by arvind_ds
Which variable you want to change.? Well you can use datastage administerator tool to change the environment variables.If the variable is local to your Windows client machine, use My Computer --> Properties --> Advanced --> Environment variables.

HTH

Posted: Wed Aug 17, 2011 3:29 am
by Murali4u
I want to be bit clear.. Its datastage administrator variable, not the one in my computer.. I want to dynamically assign/modify the values in the environmental variable not static.

Posted: Wed Aug 17, 2011 4:44 am
by arvind_ds
Include the desired variable into your datastage job by using job properties of that job and specify the intended value at run time.

Posted: Wed Aug 17, 2011 5:43 am
by Murali4u
Thanx Arvind for your comments..

The sequence is a scheduled one. During the initial execution, it will carry one value and at the end of the job execution, the value need to be assigned with a different value. I just want to know how to modify the value of that environmental variable in datastage.

Posted: Wed Aug 17, 2011 6:18 am
by arvind_ds
Well in that case use a variable activity stage to store the value of the intended variable and use it accordingly during initiation/end of the job sequence.