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.
How to assign value to Environment Variable from a table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can, but you don't want to, because the UNIX based ODBC drivers that you will need to license cost megabucks. If you would like to research this strategy search the forum for "BCI".
A better approach is a job sequence that runs a job to extract the values from the table into either a text file or a hashed file, then to pick them up from there with a User Variables activity. The user variables can then be used to assign replacement values for the environment variables or for the job parameter settings.
A better approach is a job sequence that runs a job to extract the values from the table into either a text file or a hashed file, then to pick them up from there with a User Variables activity. The user variables can then be used to assign replacement values for the environment variables or for the job parameter settings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.