Change/Modify the DS Environmental variable value

Murali4u · Post by **Murali4u** » Wed Aug 17, 2011 2:22 am

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.

arvind_ds · Post by **arvind_ds** » Wed Aug 17, 2011 2:42 am

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

Murali4u · Post by **Murali4u** » Wed Aug 17, 2011 3:29 am

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.

arvind_ds · Post by **arvind_ds** » Wed Aug 17, 2011 4:44 am

Include the desired variable into your datastage job by using job properties of that job and specify the intended value at run time.

Murali4u · Post by **Murali4u** » Wed Aug 17, 2011 5:43 am

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.

arvind_ds · Post by **arvind_ds** » Wed Aug 17, 2011 6:18 am

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.