Page 1 of 1

Global Variable

Posted: Thu Oct 31, 2013 1:53 pm
by Marley777
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.

Posted: Thu Oct 31, 2013 2:17 pm
by Mike
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

Posted: Thu Oct 31, 2013 2:25 pm
by Marley777
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?

Posted: Thu Oct 31, 2013 2:33 pm
by Mike
Execute command activity within a job sequence.

Mike