Passing values between jobs (routines) in a sequence

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
evee1
Premium Member
Premium Member
Posts: 96
Joined: Tue Oct 06, 2009 4:17 pm
Location: Melbourne, AU

Passing values between jobs (routines) in a sequence

Post by evee1 »

I need to build a job sequence that contains few jobs and I need to pass a value from one to the other. Job A calls an SP that returns a value. This value is used as an input parameter in the job B. How best to implement this scenario?
In the past I used sequential files to store values between jobs in a sequence, but I wonder whether there is any better way to do it and keep the file system out of the picture.
arunkumarmm
Participant
Posts: 246
Joined: Mon Jun 30, 2008 3:22 am
Location: New York
Contact:

Post by arunkumarmm »

Set the value as user status in Job A and pass it on to Job B in the Sequence.
Arun
evee1
Premium Member
Premium Member
Posts: 96
Joined: Tue Oct 06, 2009 4:17 pm
Location: Melbourne, AU

Post by evee1 »

Thanks. In the meantime I have found the DSSetUserStatus. I might use this to pass the return value instead of the files.
marpadga18
Premium Member
Premium Member
Posts: 96
Joined: Fri Aug 20, 2010 8:51 am

Post by marpadga18 »

evee1 wrote:Thanks. In the meantime I have found the DSSetUserStatus. I might use this to pass the return value instead of the files.
@evee1 could you tell me what are the steps to pass the value to sequencer using User status?
Thanks M
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Three steps:

1. Do an exact search for DSSetUserStatus
2. Read thru the matching posts
3. Implement!

:wink:
-craig

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