Passing parameters or values across server jobs

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
prerana dixit
Participant
Posts: 14
Joined: Tue Aug 25, 2009 12:53 am

Passing parameters or values across server jobs

Post by prerana dixit »

Are there any ways of passing parameters or values across server jobs in datastage.
Scenario:Job 'A' would execute and based on the result of the Job we want either Job 'B' or Job 'C' to execute. Hence the result of Job 'A' would determine the sequence of operation.Job 'A' may be within job 'B'.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Yes.

You can trigger different jobs depending on the result / response from a job.

Maybe you can provide more information on your requirement to get better response.
prerana dixit
Participant
Posts: 14
Joined: Tue Aug 25, 2009 12:53 am

Passing parameters or values across server jobs

Post by prerana dixit »

Scenario: Job 'A' is within job 'B'. If we assign some value to a variable or parameter in job 'A',are there any ways of passing this value to outer job 'B' i.e can we refer this variable or parameter in the outer job 'B'.This parameter is environment variable and we want to change its value in inner job 'A' and use it to perform operations in job 'B'
DS_SUPPORT
Premium Member
Premium Member
Posts: 232
Joined: Fri Aug 04, 2006 1:20 am
Location: Bangalore

Post by DS_SUPPORT »

How Job B is called from Job A, if you could say that clearly, you will get exact answer.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Search here for USERSTATUS and the SetUserStatus routine you can write to leverage it. Sequence jobs can easily pull information from this and pass it to other jobs and/or control the job flow with it.
-craig

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