A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
evee1
Premium Member
Posts: 96 Joined: Tue Oct 06, 2009 4:17 pm
Location: Melbourne, AU
Post
by evee1 » Thu May 19, 2011 11:04 pm
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 » Fri May 20, 2011 10:12 am
Set the value as user status in Job A and pass it on to Job B in the Sequence.
Arun
evee1
Premium Member
Posts: 96 Joined: Tue Oct 06, 2009 4:17 pm
Location: Melbourne, AU
Post
by evee1 » Mon May 23, 2011 1:14 am
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
Posts: 96 Joined: Fri Aug 20, 2010 8:51 am
Post
by marpadga18 » Fri Jul 22, 2011 1:12 pm
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
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Jul 22, 2011 2:23 pm
Three steps:
1. Do an exact search for
DSSetUserStatus
2. Read thru the matching posts
3. Implement!
-craig
"You can never have too many knives" -- Logan Nine Fingers