Pass unique process ID to downstram process

[Aggie99]

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.

[Sainath.Srinivasan]

There are many items you can send as unique for a process.

But what is your intention about it? i.e. how do you plan to use it later?

[chulett]

OK, so what do you need help with - the query part or the pass downstream part? Specifically, what did you try and what problem are you having? Right now you're being way too... generic.

[Aggie99]

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.

[Aggie99]

I need suggestion on the "Passing the id down". Not SQL.

thanks,

[ray.wurlod]

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.

[chulett]

Right, search here for USERSTATUS and DSSetUserStatus for examples.