Collection Contents Index ROLLBACK statement ROLLBACK TRIGGER statement pdf/chap9.pdf

Reference Manual
   CHAPTER 9. SQL Statements     

ROLLBACK TO SAVEPOINT statement


Function 

To cancel any changes made since a SAVEPOINT.

Syntax 

ROLLBACK TO SAVEPOINT [savepoint-name]

Permissions 

There must have been a corresponding SAVEPOINT within the current transaction.

Side effects 

None.

See also 

SAVEPOINT statement

RELEASE SAVEPOINT statement

ROLLBACK statement

Description 

The ROLLBACK TO SAVEPOINT statement will undo any changes that have been made since the SAVEPOINT was established. Changes made prior to the SAVEPOINT are not undone; they are still pending. For a description of savepoints, see Savepoints within transactions.

The savepoint-name is an identifier that was specified on a SAVEPOINT statement within the current transaction. If savepoint-name is omitted, the most recent savepoint is used. Any savepoints since the named savepoint are automatically released.

Standards and compatibility 


Collection Contents Index ROLLBACK statement ROLLBACK TRIGGER statement pdf/chap9.pdf