RELEASE SAVEPOINT statement

Description

Releases a savepoint within the current transaction.

Syntax

RELEASE SAVEPOINTsavepoint-name ]

Usage

The savepoint-name is an identifier specified on a SAVEPOINT statement within the current transaction. If savepoint-name is omitted, the most recent savepoint is released.

For a description of savepoints, see Chapter 1, “Using Procedures and Batches” in the System Administration Guide: Volume 2. Releasing a savepoint does not perform any type of COMMIT; it simply removes the savepoint from the list of currently active savepoints.


Side effects

None.

Standards

Permissions

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

See also

ROLLBACK TO SAVEPOINT statement

SAVEPOINT statement