commit on sequence success
Posted: Tue Nov 09, 2010 11:58 pm
Hi
We are using the Oracle Enterprise stage to read and write to our database. Is it possible to roll back transactions in Datastage if a sequence fails?
ie in the sequence
job1 writes to db, succeeds
job2 fails for some reason
job3 never starts because job2 failed
Is there a feature in Datastage which allows for the rollback of the job1 transactions?
We are using the Oracle Enterprise stage to read and write to our database. Is it possible to roll back transactions in Datastage if a sequence fails?
ie in the sequence
job1 writes to db, succeeds
job2 fails for some reason
job3 never starts because job2 failed
Is there a feature in Datastage which allows for the rollback of the job1 transactions?