How to assign value to Environment Variable from a table
Posted: Wed Jun 07, 2006 11:40 pm
Hi Folks,
I'm trying to use environment variables with DataStage and I'm having a little difficulty that I hope someone can help me with.
Background:
I have some server jobs that contains some Sequential File,Transformer and ODBC stages. I have defined some environment variables using DS Administrator and I have used that variables to define Data source name,User name and password in ODBC stage(eg #$xyz#).
QUESTION::
Here it takes the values which I have defined in Administrator, Now I want to define that values in some Table so that the Environment varibles will pick that value from that table.
How do I do that??
Any ideas are most welcome, thanks...
If you need more info to help, please let me know and I'll email you whatever you need.
I'm trying to use environment variables with DataStage and I'm having a little difficulty that I hope someone can help me with.
Background:
I have some server jobs that contains some Sequential File,Transformer and ODBC stages. I have defined some environment variables using DS Administrator and I have used that variables to define Data source name,User name and password in ODBC stage(eg #$xyz#).
QUESTION::
Here it takes the values which I have defined in Administrator, Now I want to define that values in some Table so that the Environment varibles will pick that value from that table.
How do I do that??
Any ideas are most welcome, thanks...
If you need more info to help, please let me know and I'll email you whatever you need.