SQL support / Database transactions |
Destroys the specified savepoint in the current transaction.
RELEASE SAVEPOINT spname
Use the RELEASE SAVEPOINT instruction to delete a savepoint defined by the SAVEPOINT instruction. See database documentation for more details about the behavior of this SQL statement. Note for example that IBM® Informix® IDS will also release any savepoint that has been declared between the specified savepoint and the RELEASE SAVEPOINT instruction.
MAIN DATABASE stock BEGIN WORK DELETE FROM items SAVEPOINT sp1 INSERT INTO items VALUES ( ... ) SAVEPOINT sp2 UPDATE items SET ... RELEASE SAVEPOINT sp1 ROLLBACK WORK TO SAVEPOINT COMMIT WORK END MAIN