Usage of $ENV variable
Posted: Thu Nov 26, 2009 10:32 pm
Hi,
I have a job which needs to be re-used with multiple parameters.
The job has an oracle stage which extracts data and stores it in a file.
I have the same table in different schema. So each has different value for schema/userid and password(Encrypted). All these values need to be stored in Datastage Administrator.
We have the following parameters for the job
Source_schema
Source_user_id
Source_password
These parameters need to have different values for different runs. But these are parameterized in administrator as the password value need to be encrypted.
I thought of setting the values for these parameters during each run in unix with export command and use $ENV. But i think this value will be overriden during the run which will take the value from Administrator, isnt it..
Is there a way to store the values like this in administrator and pass those values to the job during job run..
In Administrator
Source_schema1=xxxx
Source_schema2=yyyy
Source_userid1=nnnn
Source_userid2=hjbj
Source_password1=*****(Encrypted)
Source_password2=******(Encrypted).
and when the job runs
Source_schema should be passed with value of Source_schema1
Source_userid should be passed with the value of Source_userid1
Source_password should be passed with the value of Source_password1
I have a job which needs to be re-used with multiple parameters.
The job has an oracle stage which extracts data and stores it in a file.
I have the same table in different schema. So each has different value for schema/userid and password(Encrypted). All these values need to be stored in Datastage Administrator.
We have the following parameters for the job
Source_schema
Source_user_id
Source_password
These parameters need to have different values for different runs. But these are parameterized in administrator as the password value need to be encrypted.
I thought of setting the values for these parameters during each run in unix with export command and use $ENV. But i think this value will be overriden during the run which will take the value from Administrator, isnt it..
Is there a way to store the values like this in administrator and pass those values to the job during job run..
In Administrator
Source_schema1=xxxx
Source_schema2=yyyy
Source_userid1=nnnn
Source_userid2=hjbj
Source_password1=*****(Encrypted)
Source_password2=******(Encrypted).
and when the job runs
Source_schema should be passed with value of Source_schema1
Source_userid should be passed with the value of Source_userid1
Source_password should be passed with the value of Source_password1