ROLLBACK
The ROLLBACK statement can be used to either:
- End a unit of work and back out all the relational database changes that
were made by that unit of work. If relational databases are the only recoverable
resources used by the application process, ROLLBACK also ends the unit of
work.
- Back out only the changes made after a savepoint was set within the unit
of work without ending the unit of work. Rolling back to a savepoint enables
selected changes to be undone.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.