Page 1 of 1
profiles passing
Posted: Thu Sep 14, 2006 10:02 pm
by vardhan354
Hi,
How to pass the job parameters in datastage jobs for different environments using profiles(unix).
please help me about process,Any documentation regarding this is helpful.
Thanks for your help.
Posted: Fri Sep 15, 2006 12:04 am
by ray.wurlod
Environment variables.
Posted: Fri Sep 15, 2006 10:03 am
by vardhan354
yes Ray, it is Environment Variables.
How to pass the environment variables from unix, when the jobs are migrated from dev-test-prod.
Please give your valuble suggestions.
Thanks
Posted: Fri Sep 15, 2006 2:45 pm
by vardhan354
Can any help in this issue.
Posted: Fri Sep 15, 2006 3:46 pm
by kduke
Yes you can use environment variables as parameter values. There are several other best practices like having a ini file or a text file which is read with all the parameter values like
pSourceDsn=MyDsn
pSourceUser=EtlUser
pSourcePwd=MyPassword
Do a search on DSParams to see how parameters are can be moved around.
Posted: Fri Sep 15, 2006 6:07 pm
by ray.wurlod
vardhan354 wrote:Can any help in this issue.
I do not get up at 2:45am (my local time when you posted this) just to answer DSXchange posts!
Posted: Fri Sep 15, 2006 6:09 pm
by ray.wurlod
Create job parameters using "Add Environment Variable". Use one of the special default values.
- $ENV obtain value from executing user's environment
$PROJDEF obtain value from project (set in Administrator client)
Posted: Fri Sep 15, 2006 6:21 pm
by kumar_s
If you are looking at the different values of a variable in different user id, $ENV will be prompt aproach, as mentioned in the above.