Q: Insert into 2 stages as single transaction ?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
trobinson
Participant
Posts: 208
Joined: Thu Apr 11, 2002 6:02 am
Location: Saint Louis
Contact:
Contact trobinson

Post by trobinson »

Assuming that the plug-in type (e.g. Oracle) supports transaction grouping and that the two output tables are in the same RDBMS and that they are in the same output stage linked to the same transformer stage, then you can group the two (or more) output links as a transaction group. Both links will have to complete successfully to commit the group. It is on the output plug-in stage in the Input tab within the Transaction Handling tab.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”