RELEASE SAVEPOINT statement

The RELEASE SAVEPOINT statement is used to indicate that the application no longer wishes to have the named savepoint maintained. After this statement has been invoked, rollback to the savepoint is no longer possible.

Invocation

This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.

Authorization

None required.

Syntax

Read syntax diagramSkip visual syntax diagramRELEASETOSAVEPOINT savepoint-name

Description

savepoint-name
Specifies the savepoint that is to be released. Any savepoints nested within the named savepoint are also released. Rollback to that savepoint, or any savepoint nested within it, is no longer possible. If the named savepoint does not exist in the current savepoint level (see the Rules section in the description of the SAVEPOINT statement), an error is returned (SQLSTATE 3B001). The specified savepoint-name cannot begin with 'SYS' (SQLSTATE 42939).

Notes

  • The name of the savepoint that was released can now be reused in another SAVEPOINT statement, regardless of whether the UNIQUE keyword was specified on an earlier SAVEPOINT statement specifying this same savepoint name.

Example

Release a savepoint named SAVEPOINT1. 
   RELEASE SAVEPOINT SAVEPOINT1