Page 1 of 1

Passing parameters or values across server jobs

Posted: Wed Nov 18, 2009 3:28 am
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'.

Posted: Wed Nov 18, 2009 3:33 am
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.

Passing parameters or values across server jobs

Posted: Wed Nov 18, 2009 4:01 am
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'

Posted: Wed Nov 18, 2009 4:21 am
by DS_SUPPORT
How Job B is called from Job A, if you could say that clearly, you will get exact answer.

Posted: Wed Nov 18, 2009 6:39 am
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.