Page 1 of 1

Passing different Parms into a job

Posted: Tue Feb 19, 2008 7:20 am
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

Posted: Tue Feb 19, 2008 7:26 am
by chulett
Two Job Activity stages? You could use a Nested Condition stage to check the parameter and branch accordingly.