transaction Command

A transaction involves accessing the database or producing a change in the database. All MQL commands involve transactions.

This page discusses:

User Level

System Administrators

Syntax

Several MQL commands enable you to explicitly start, abort, and commit transactions.

abort transaction [NAME];
commit transaction;
print transaction;
start transaction [read] [historyoff] [triggeroff] [data NAME VALUE {data NAME VALUE}];
set transaction wait|nowait|savepoint [NAME];

These commands enable you to extend the transaction boundaries to include more than one MQL command.

  • If you are starting a transaction, use the read option if you are only reading.
  • Without any argument, the start transaction command allows reading and modifying the database.