SAVEPOINT

The SAVEPOINT statement is used to set a savepoint within a transaction.  You can specify UNIQUE, ON ROLLBACK RETAIN CURSORS, or ON ROLLBACK RETAIN LOCKS.

Example:

Create a savepoint called SAVEPOINT1.

SAVEPOINT SAVEPOINT1

For more information, see SAVEPOINT in the SQL Reference topic in the Information CenterLink to Information center.