Implicit User ID and Password for ODBC stage.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
leomauer
Premium Member
Premium Member
Posts: 100
Joined: Mon Nov 03, 2003 1:33 pm

Implicit User ID and Password for ODBC stage.

Post by leomauer »

I am new to PX, but I know Server pretty well.
I used to create ODBC unload/load jobs in DS Server omitting User ID and Password. Then at runtime the connection acquire these values of whoever runs the job from the system.
I tried to do it in PX and got password/uid incorrect message.
Does anybody know the way to create PX job with ODBC to acquire the password/uid at runtime?
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Parallel jobs are a new mindset. Your only option is to use job parameters.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”