Need to pass a parameter across all jobs

xch2005 · Post by **xch2005** » Mon Jun 13, 2011 1:40 pm

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

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Mon Jun 13, 2011 2:37 pm

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

synsog · Post by **synsog** » Tue Jun 14, 2011 8:31 am

Thanks Andy, this helps.

xch2005 · Post by **xch2005** » Tue Jun 14, 2011 8:33 am

It works for me now.

Andy, thanks a lot.

fmou · Post by **fmou** » Sat Jul 30, 2011 9:53 am

in the job sequence setup a "user variable" using the User Variable Activity stage first

THe OP was on DataStage Release: 7x. Is such User Variable Activity stage available in DataStage 7?

I searched trough the Parallel Job Developer's Guide, Version 7.5.1, but didn't find a match for "User Variable".

Thanks

chulett · Post by **chulett** » Sat Jul 30, 2011 10:17 am

Yes, it exists. It's a Sequence job stage.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 30, 2011 5:12 pm

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.

chulett · Post by **chulett** » Sat Jul 30, 2011 9:17 pm

No, I've used it back on a 7.5.1a system, so I'd say in the 7.5 release.

zulfi123786 · Post by **zulfi123786** » Sun Jul 31, 2011 4:23 am

fmou wrote:I searched trough the Parallel Job Developer's Guide, Version 7.5.1, but didn't find a match for "User Variable".

Search for the same in "DataStage Designer Guide , Version 7.5.1"

fmou · Post by **fmou** » Tue Aug 02, 2011 8:08 am

Thanks zulfi,

User Variables Activity Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-36