Passing Parameters between jobs

srekant · Post by **srekant** » Fri Dec 02, 2005 8:15 am

Hi all,

How can i pass the output(3 columns) of a job as parameters to other job.

Working on DS7.5 EE.

ArndW · Post by **ArndW** » Fri Dec 02, 2005 8:28 am

A job does not have "output" in the sense that you would like. In your case you have 3 columns - times how many rows?

Do you wish to call a job one time for each row and pass 3 columns/values as parameters to that job?

ray.wurlod · Post by **ray.wurlod** » Fri Dec 02, 2005 3:41 pm

The easiest ways are to have Job A write the values to a file and have the job controller (sequence) read that file before invoking Job B, or to have Job A load the values as a delimited string into its user status area and have the job controller access and parse that value before invoking job B.

kumar_s · Post by **kumar_s** » Sat Dec 03, 2005 4:59 am

Hi,
As ray suggested intermediate file will be the simplest way. We can directly inherit only Jobname, Jobstatus or UserStatus from a job which can be passed as parameter.

Hi ray,

Is there ant way we can pass a value of a column a used in job (lets assume it has just single row) to its own paramter without using external job control.

-Kumar

chulett · Post by **chulett** » Sat Dec 03, 2005 8:34 am

Kumar - you mentioned one such way in your post - via the UserStatus area.

ray.wurlod · Post by **ray.wurlod** » Sat Dec 03, 2005 8:59 pm

No job, once started, can alter the value of any of its own job parameters.

chulett · Post by **chulett** » Sat Dec 03, 2005 10:06 pm

Is that what we are discussing? I thought the topic was passing parameters between jobs.

ray.wurlod · Post by **ray.wurlod** » Sun Dec 04, 2005 1:20 pm

I intuit that the thought process was "if I can change Job A's parameter values in Job A, then Job B can use DSGetParamInfo() to read those values" and sought to pre-empt that line of thinking.