when does ds do commit in db2 api?

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
caola
Participant
Posts: 10
Joined: Tue Jul 24, 2007 3:42 am

when does ds do commit in db2 api?

Post by caola »

There is before/after sql and main sql in db2 api stage. When will ds do commit?
is it:
run before sql--->commit--->run main sql--->commit--->run after sql--->commit

or it treats before/main/after sql as one transaction and do just one commit at last?
:)
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”