Using a job parameter for DB2 user password

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
btaylor
Participant
Posts: 2
Joined: Mon Nov 28, 2005 9:02 am

Using a job parameter for DB2 user password

Post by btaylor »

I am trying to use a job parameter for the user password of a DB2 table but I cannot figure out how to enter it. If enter the actual password in the password field the job works fine. If I create a job parameter for the password and enter the parameter name in the password field the job fails on invalid password.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

You are using # around the job parameter, like #InstancePassword#? If you use View Data on the stage, it should prompt you to enter parameters utilized.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply