hi gurus,
I am tying to query a database table to get an unique process key to pass to downstream DataStage Parallel processes.
How can I do this? Can you give me some suggestions.
thanks in advance.
Pass unique process ID to downstram process
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
yes, it is a bit generic.
We have a database table that stores unique batch IDs and other attributes on Oracle DB1.
Every batch run will kick off a list of child processes that populate tables in Oracle DB2. All the child processes should capture the same Batch ID number and store them along with other fields.
I have a set of Parallel jobs, and will use Sequencers to chain them up.
I try to query DB1 for Batch ID once, then pass it to downstream child processes. But need suggestions.
We have a database table that stores unique batch IDs and other attributes on Oracle DB1.
Every batch run will kick off a list of child processes that populate tables in Oracle DB2. All the child processes should capture the same Batch ID number and store them along with other fields.
I have a set of Parallel jobs, and will use Sequencers to chain them up.
I try to query DB1 for Batch ID once, then pass it to downstream child processes. But need suggestions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
One job (a server job is best for processing one row) to query the table and park the value into the job's user status area. In the calling sequence the user status area can be interrogated as an activity variable in any downstream activity.
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.