Hi Can any one help me how to use the job parameter for the job.
Job-1 is giving the output as two feilds Id(param1) and the where_condition clause(param2).
job-2 will use the above feilds in as the parameter.
Can i know how to call the job parameter of job1.
because i want to use in the job2 SQL where condition(job param2- job1).
So please suggest how to proceed.
How to use job parameters as the input
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In Job 1 load both, separated by some convenient character such as tab, into the job's user status area.
In the job sequence retrieve Job1's user status area and decode into the two parameter expressions for Job2.
In the job sequence retrieve Job1's user status area and decode into the two parameter expressions for Job2.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.