How to use job parameters as the input

monaz · Post by **monaz** » Tue Mar 31, 2009 4:54 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 31, 2009 6:35 am

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.