Multiple update statment in teradata API stage.
Posted: Thu Nov 13, 2008 6:49 am
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.
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.