DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message

Group memberships:
Premium Members

Joined: 17 Oct 2006
Posts: 64
Location: Toronto
Points: 625

Post Posted: Thu Nov 13, 2008 6:49 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows

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

Joined: 14 Aug 2008
Posts: 79

Points: 545

Post Posted: Tue Nov 18, 2008 12:41 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours