how to pass dataset value as a parameter to next job

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
prasson_ibm
Premium Member
Premium Member
Posts: 536
Joined: Thu Oct 11, 2007 1:48 am
Location: Bangalore

how to pass dataset value as a parameter to next job

Post by prasson_ibm »

Hi,
I have a job where i am generating GUUID using java call and storing into dataset and GUUID need to be passed in where clause of another job,so is there any way i can pass this dataset value as a parameter to another job.

I know after storing this value in file(sequential file) i can pass but i dont want to change current job design which is storing it in dataset :cry:
bhasds
Participant
Posts: 79
Joined: Thu May 27, 2010 1:49 am

how to pass dataset value as a parameter to next job

Post by bhasds »

I think you can use orchadmin command in after job subroutine to get the value in ascii format in a file.
And then use that value as parameter in the required job.

Please let me know if it works.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

orchadmin dump specifically.
-craig

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