call column value of job A in job B (both jobs in a same seq

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
getsatish_gk
Participant
Posts: 104
Joined: Sat Dec 24, 2005 1:26 am
Location: Bengaluru

call column value of job A in job B (both jobs in a same seq

Post by getsatish_gk »

Hi all,

Calling a column value of job A in job B; both jobs are in same sequence
can this be achieved by 'User Variable Activity' stage / After job routine?

Thanks in adv
ddevdutt
Participant
Posts: 47
Joined: Wed Aug 22, 2007 2:38 pm

Re: call column value of job A in job B (both jobs in a same

Post by ddevdutt »

Can you be a little more specific? What is it you are trying to do?
DD

Success is right around the corner
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You'll need to rephrase your question as we don't understand what "Calling a column value of job A in job B" means. Sorry.
-craig

"You can never have too many knives" -- Logan Nine Fingers
getsatish_gk
Participant
Posts: 104
Joined: Sat Dec 24, 2005 1:26 am
Location: Bengaluru

Post by getsatish_gk »

the requirement is to read and use the field value generated in previous job.

lets say i have two jobs (Job A and Job B) both is same sequence, and say Job A is populating col 1 and i want to call this value into Job B.

(just consider only one value populating per run)

Sorry, i might be in hurry if earlier question was not in detail

Thanks in adv.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sounds like a job for USERSTATUS. Search here for that word and also "SetUserStatus" to find discussions on its use and example code.
-craig

"You can never have too many knives" -- Logan Nine Fingers
getsatish_gk
Participant
Posts: 104
Joined: Sat Dec 24, 2005 1:26 am
Location: Bengaluru

Post by getsatish_gk »

Thanks a lot Craig, I got the way 8)
Post Reply