release savepoint

Release a transaction savepoint

Syntax

release_stmt:
          RELEASE SAVEPOINT savepoint_id

Description

The RELEASE SAVEPOINT statement is used to release a transaction savepoint identified by savepoint_id that was established by a prior execution of a SAVEPOINT statement. Once a savepoint is released, all of the changes made since that savepoint can only be discarded by a ROLLBACK of the entire transaction.

Of course, this statement requires that a transaction has been started and that a SAVEPOINT has been executed for the specified savepoint_id.

Savepoints are also discarded through execution of a ROLLBACK to a prior savepoint, or a ROLLBACK or COMMIT of the transaction.

Example

start trans;
insert into acctmgr ... new account manager
savepoint new_patron;
insert into patron ... new patron for new acct manager
insert into patron ... another for the new acct manager
	... no problems encountered      release savepoint new_patron;
... other changes
commit;