Skip to main content

This is documentation for Caché and Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

Please read this important announcement about the future of Caché and Ensemble maintenanceOpens in a new tab. Contact your account team to migrate to InterSystems IRIS.

TRANSACTION ABORT

Reverts all changes made during the current transaction.

Synopsis

TRANSACTION ABORT

Description

The TRANSACTION ABORT statement reverts all changes made during the current transaction initiated by a TRANSACTION START statement. All file changes issued during the transaction are undone, returning the data to the state prior to the TRANSACTION START.

To commit the changes made during the current transaction, issue a TRANSACTION COMMIT statement, rather than a TRANSACTION ABORT statement.

Note:

Caché MVBasic supports two sets of transaction statements:

  • UniData-style TRANSACTION START, TRANSACTION COMMIT, and TRANSACTION ABORT.

  • UniVerse-style BEGIN TRANSACTION, COMMIT, ROLLBACK, and END TRANSACTION.

These two sets of transaction statements should not be combined.

Locks and Transactions

File locks and record locks that were taken out during a transaction are released at the end of a transaction. If there are nested transactions, the release of locks taken out during the inner transactions is delayed until the completion of the outermost transaction. This release of locks is part of a successful TRANSACTION COMMIT or TRANSACTION ABORT operation. Locks are described in the LOCK statement.

See Also

TRANSACTION COMMITNext section
Previous sectionTHROW
FeedbackOpens in a new tab