602SQL Documentation Index  
<­SAVEPOINT Statement UpTransactions and Savepoints    

RELEASE SAVEPOINT Statement

statement_RELEASE_SAVEPOINT ::= RELEASE SAVEPOINT savepoint

The RELEASE SAVEPOINT statement deletes the specified savepoint created by the SAVEPOINT statement. All savepoints that were created in this transaction after the specified savepoint are deleted as well. Savepoints that are not deleted explicitly using this statement are deleted when the transaction is terminated.

If the specified savepoint does not exist, the error sqlstate 3B001 occurs.

<­SAVEPOINT Statement UpTransactions and Savepoints