Multiple update statment in teradata API 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
sanjumsm
Premium Member
Premium Member
Posts: 64
Joined: Tue Oct 17, 2006 11:29 pm
Location: Toronto

Multiple update statment in teradata API stage.

Post by sanjumsm »

HI,

I am using teradata api stage where using 10 update statements.
my requirment is if in between any update statement abort then previous succesfully run statement also rollback.

For Ex: If 7th outof 10 , update statement failed , then first 6 succesfully statement also rollback.

But I checked in teradata api stage , if 7th update statement failed then job run succesfully and first 6 statements run succesfully committed.

please tell me how to solve this problem.
sanjeev kumar
toshea
Participant
Posts: 79
Joined: Thu Aug 14, 2008 6:46 pm

Post by toshea »

You can't do it with the Teradata API stage, because the Teradata API stage only runs in ANSI transaction mode. Use either the Teradata Connector or the Stored Procedure stage. Both of those stages support Teradata transaction mode. In Teradata transaction mode, any error will rollback the current transaction.
Post Reply