Assigning values from file to paramter

[Scope]

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.

[sud]

So, what's stopping you?

[AmeyJoshi14]

So, what's stopping you?

[santhu]

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.

[ray.wurlod]

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.