Hi,
I have 10 jobs to be run in parallel and need to pass a value to a parameter from the sequence job which is in all jobs ie. in runtime.
eg. PR_DATE needs to have current_date -1 in all the jobs.
Is there a way how this can be acheived?
Thanks for your time.
Thanks
Need to pass a parameter across all jobs
Moderators: chulett, rschirm, roy
If I understand your question (let me restate to be clear)... You have a job sequence running 10 jobs. You need to set a parameter to a value and then pass that value to all 10 jobs.
If that is the case, then in the job sequence setup a "user variable" using the User Variable Activity stage first (before the jobs).
Inside the UVA stage, click on the User Variables tab and then right-click on the blank area and select "add row". Give your variable a name and then set the expression to Date() -1.
If your UVA stage is called SetVar and your actual variable is called Yesterday (for example), then you can use it to set the appropriate parameters in your jobs. It would show up under "Activity Variables" as SetVar.Yesterday
If that is the case, then in the job sequence setup a "user variable" using the User Variable Activity stage first (before the jobs).
Inside the UVA stage, click on the User Variables tab and then right-click on the blank area and select "add row". Give your variable a name and then set the expression to Date() -1.
If your UVA stage is called SetVar and your actual variable is called Yesterday (for example), then you can use it to set the appropriate parameters in your jobs. It would show up under "Activity Variables" as SetVar.Yesterday
THe OP was on DataStage Release: 7x. Is such User Variable Activity stage available in DataStage 7?in the job sequence setup a "user variable" using the User Variable Activity stage first
I searched trough the Parallel Job Developer's Guide, Version 7.5.1, but didn't find a match for "User Variable".
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I believe that the User Variable activity was introduced in version 8.x.
But a version 7.x solution would involve creating a parameter in the sequence itself, and passing that to the ten job activities.
But a version 7.x solution would involve creating a parameter in the sequence itself, and passing that to the ten job activities.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore