Hi all,
How can i pass the output(3 columns) of a job as parameters to other job.
Working on DS7.5 EE.
Passing Parameters between jobs
Moderators: chulett, rschirm, roy
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?
Do you wish to call a job one time for each row and pass 3 columns/values as parameters to that job?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.