Passing different Parms into a job

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
kishorenvkb
Participant
Posts: 54
Joined: Mon Dec 24, 2007 9:27 am

Passing different Parms into a job

Post by kishorenvkb »

Hi All,

I have a UNIX script calling a datastage sequence with some parameters from the UNIX script.
The sequence calls a datastage job that fetches the data from Teradata database.
Following is the requirements: If parameter A is passed from the UNIX script to the sequence, the datastage job called within the sequence must execute with useridA and PasswdA. If B is passed in as a parameter, the datastage job must be executed with useridB and PasswdB.
All userids and passwords are defined as environment variables.
Please assist on how I can achieve this?

Thanks
Kishore
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Two Job Activity stages? You could use a Nested Condition stage to check the parameter and branch accordingly.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply