profiles passing

vardhan354 · Post by **vardhan354** » Thu Sep 14, 2006 10:02 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 15, 2006 12:04 am

Environment variables.

vardhan354 · Post by **vardhan354** » Fri Sep 15, 2006 10:03 am

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

vardhan354 · Post by **vardhan354** » Fri Sep 15, 2006 2:45 pm

Can any help in this issue.

kduke · Post by **kduke** » Fri Sep 15, 2006 3:46 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 15, 2006 6:07 pm

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!

ray.wurlod · Post by **ray.wurlod** » Fri Sep 15, 2006 6:09 pm

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)

kumar_s · Post by **kumar_s** » Fri Sep 15, 2006 6:21 pm

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.