how to parameterize the db sequence password field

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

how to parameterize the db sequence password field

Post by abyss »

how to reference the password value from parameter set into db sequence password filed in PxSCD stage?

I created a PxSCD data connector and load it in my scd stage but job gives me incorrect user name and password error unless I hard code the password into that field, bloody hell!

thanks
Abyss
FranklinE
Premium Member
Premium Member
Posts: 739
Joined: Tue Nov 25, 2008 2:19 pm
Location: Malvern, PA

Post by FranklinE »

The solution I use:

Create encrypted environment variable for password, and enter it via Administrator or a script that updates the variable.

Wherever you add the variable, in the Job Properties Parameter tab or in a parameter set, the default value must be $PROJDEF.

If that is close to what you are already doing, we both need advice here, because it should work.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
Post Reply