![]() ![]() |
|
TRANSABORTThis statement is used to abort the current transaction and reverse any updates to the database.
COMMAND SYNTAXTRANSABORT {abort-text} [THEN statement | ELSE statement]
SYNTAX ELEMENTSabort-text specifies an optional text string to save in the transaction abort record. A THEN or ELSE (or both) statement is required. The THEN clause will be be executed if the transaction is successfully aborted. The ELSE clause will be executed if the transaction abort fails for any reason.
NOTESAny record locks set during the transaction will be released upon successful completion. |