The abort statement reverses some or all of the updates performed by a multi-query transaction. If you do not specify a savepoint, abort undoes all the updates that were performed by the transaction, closes any open cursors, and terminates the transaction.

If you specify a savepoint, abort undoes all the updates that were performed between the savepoint savepoint_name and the abort statement. Open cursors are closed, but the entire transaction is not terminated (as shown in the second example, below).

For more information, see Savepoint Statement--Declare Marker in an MQT.