DB2 10.5 for Linux, UNIX, and Windows

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 diagram
            .-TO-.                              
>>-RELEASE--+----+--SAVEPOINT--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

Example

Release a savepoint named SAVEPOINT1.
   RELEASE SAVEPOINT SAVEPOINT1