hai
i have a parameter file. i want to pass values in parameter file to Job sequence paramters
eg:
file.txt
--------------------------
username:abc
password:xxx
----------------------------
i want to pass this username and password to job sequence parameters.
Assigning values from file to paramter
Moderators: chulett, rschirm, roy
Re: Assigning values from file to paramter
So, what's stopping you?
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Re: Assigning values from file to paramter
sud wrote:So, what's stopping you?
Hi,
Storing and Retreiving user id / password and other sensitive credentials is not a good practice.
Work with your DataStage admin to have these database credentials setup as DataStage Environmental variables in DS Admin for the given project.
Once the above DS Env variables are setup, you can use those invoke those env variables in respective sequence / job with $PROJDEF as the default value so that it takes the value setup at the project level.
Storing and Retreiving user id / password and other sensitive credentials is not a good practice.
Work with your DataStage admin to have these database credentials setup as DataStage Environmental variables in DS Admin for the given project.
Once the above DS Env variables are setup, you can use those invoke those env variables in respective sequence / job with $PROJDEF as the default value so that it takes the value setup at the project level.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are several techniques for reading a parameter file. Searching DSXchange will reveal at least some of them. Remember that parameter values must be set before the job run request is issued, so you will need a job sequence or controlling job.
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.