Rollback and commit If I got any abend

kumar_jalluri · New User Joined: 02 Jun 2005 Posts: 24 Location: PUNE

Hi

I have a question.

I am using three tables for updating in my program.

I have to update these tables only if everything is OK means if the program successfully completes.

If I got any abend (after first update query or 2nd update querys or all 3rd update query) it has to roll back all these updates.

Can anybnody give ur suggestion how to do it?

DavidatK · Posted: Tue Nov 28, 2006 11:14 pm

Hi kumar,

When your program abends, (if it truly abends), the system will automatically 'rollback' (backout) all of your updates to the last 'commit', or in the absence of a 'commit', to the beginning of your program.

If your program does not, in truth, abend, you can do

EXEC SQL
ROLLBACK
END-EXEC

And all of your updates will be rolled back as if your program abended.

How many rows are you updating and would want rolled back?

Dave