Assume that you want to set three savepoints at various points in a unit of work. Name the first savepoint A and allow the savepoint name to be reused. Name the second savepoint B and do not allow the name to be reused. Because you no longer need savepoint A when you are ready to set the third savepoint, reuse A as the name of the savepoint.
SAVEPOINT A ON ROLLBACK RETAIN CURSORS; . . . SAVEPOINT B UNIQUE ON ROLLBACK RETAIN CURSORS; . . . SAVEPOINT A ON ROLLBACK RETAIN CURSORS;
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.