Passing parameters in PX

[vercama]

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

[shaimil]

You should be able to achieve the same in a PX job by using a basic transformer.

If you don't see a basic transformer you'll need to add it to your palette using the customise option

[reddy12]

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

[ray.wurlod]

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.