how to use the orchestrate.columnname in the database stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsfan
Participant
Posts: 17
Joined: Tue Nov 16, 2004 11:16 pm
Location: chicago

how to use the orchestrate.columnname in the database stage

Post by dsfan »

i am new to parallel extender.i have seen some parallel jobs recently and i found out that orchestrate.columnname is used in the where clause of the oracle database stage which is accessed by a lookup stage.i want to know what this orchestrate.columnname represents.is it the column name of the other link going to the lookup stage and for using orchestrate.columnname do we have to use any job parameter.
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

orchestrate.[column_name] is basically Orchestrate's method in passing on data values that are provided on the input link to this database stage. If you ever coded in PL/SQL, you should understand this concept immediately.
Post Reply