Passing parameters in PX
Posted: Fri Sep 05, 2008 9:58 am
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
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