RELEASE SAVEPOINT statement

The RELEASE SAVEPOINT statement releases the identified savepoint and any subsequently established savepoints within a unit of recovery.

Invocation for RELEASE SAVEPOINT

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

Authorization for RELEASE SAVEPOINT

None required.

Syntax for RELEASE SAVEPOINT

Read syntax diagramSkip visual syntax diagramRELEASETOSAVEPOINT savepoint-name

Description for RELEASE SAVEPOINT

savepoint-name
Identifies the savepoint to release. If the named savepoint does not exist, an error occurs. The name must identify a savepoint that exists at the current server. After a savepoint is released, it is no longer maintained and rollback to the savepoint is no longer possible.

Notes for RELEASE SAVEPOINT

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

Example for RELEASE SAVEPOINT

Assume that a main routine sets savepoint A and then invokes a subroutine that sets savepoints B and C. When control returns to the main routine, release savepoint A and any subsequently set savepoints. Savepoints B and C, which were set by the subroutine, are released in addition to A. 
       ⋮
   RELEASE SAVEPOINT A;