Global Variable

Marley777 · Post by **Marley777** » Thu Oct 31, 2013 1:53 pm

Hi, thanks for reading.

How can I create a dynamic global variable. I want all jobs in the project to see the variable but want the ability to change the variable on the fly via a job...and all jobs would see that value.

Mike · Post by **Mike** » Thu Oct 31, 2013 2:17 pm

1. Create a project environment variable.
2. All jobs include the project environment variable as a job parameter with a value of $PROJDEF.
3. Use the dsadmin -envset command to change the value as needed.

Mike

Marley777 · Post by **Marley777** » Thu Oct 31, 2013 2:25 pm

Thanks for your help so far.

Any idea how I can change the global variable value using -envset. Can I do this in a transformer or within a datastage job?

Mike · Post by **Mike** » Thu Oct 31, 2013 2:33 pm

Execute command activity within a job sequence.

Mike