Aborts the current transaction.
The current transaction is aborted. No database alterations requested in the transaction build-up are executed.
All cursors opened by the current connection are closed.
If there is no currently active transaction, any cursors opened by the current ident are closed, but the
ROLLBACKstatement is otherwise ignored. No error code is returned in this case.
BACKUPtransaction is rolled back, all files created with
CREATE BACKUPare deleted.
ROLLBACKstatement cannot be used in a result-set procedure.
ROLLBACKstatement cannot be used within an atomic compound SQL statement, see COMPOUND STATEMENT.
ROLLBACK BACKUPstatement must be used to abort a
ROLLBACK BACKUPstatement is not supported in procedural usage contexts.
See the Mimer SQL Programmer's Manual, Transaction Handling and Database Security, for a more detailed discussion of transaction handling.
Exampleexec sql INSERT INTO sometable VALUES (:hv1, :hv2...); if SQLSTATE = "00000" then exec sql COMMIT; else exec sql ROLLBACK; end if;
For more information, see the Mimer SQL Programmer's Manual, Transaction Control Statements.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40