Hi All,
I've two PX jobs to be runned in a Sequence job:
1) the first query an Oracle DB_1 table and get the max_date from a table
2) the second accept a parameter that's a date and performs queries on Oracle DB_2
There are no possibilities of DBLinks.
How can I pass the result of the first job to the second one?
I know Server jobs that can run DSSetUserStatus routine, but PX doesen't.
I've seen many posts with similar problems, but not a precise response.
Can anybody help me?
I'd apreciated it very much.
Verena
Passing parameters in PX
Moderators: chulett, rschirm, roy
Re: Passing parameters in PX
vercama,
create a sequence
1.jobacvity stage ----first write the max_date to file.
2.execute command activity state ----open the file using cat command.
3.take the prameter from second job.
jobactivtystage--->executecommandactivity------>jobactivitystage
create a sequence
1.jobacvity stage ----first write the max_date to file.
2.execute command activity state ----open the file using cat command.
3.take the prameter from second job.
jobactivtystage--->executecommandactivity------>jobactivitystage
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why not use a server job? After all, it's only one row. A server job will be far more efficient than a parallel job for processing one row. And you can set the user status area much more easily.
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.