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
.-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
- 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