Skip to main content

COMMIT

Commits the current transaction.

Syntax​

COMMIT [WORK | TRANSACTION] [ AND CHAIN | AND NO CHAIN ]

Description​

After the current transaction commits, all changes made by the transaction are visible to users.

If you want to terminate a running transaction, execute ROLLBACK.

A warning will be reported if COMMIT is outside a transaction. An error will be reported if COMMIT AND CHAIN is outside a transaction.

Parameters​

  • [WORK | TRANSACTION]

    An additional keyword that has no effect.

  • [AND CHAIN | AND NO CHAIN]

    The option that specifies whether to start a transaction with the same characteristics immediately after the current transaction is commited. AND CHAIN specifies yes; AND NO CHAIN specifies no and is the default.

Examples​

Commit the current transaction:

COMMIT;

SQL standard compatibility​

COMMIT in Relyt is fully compatible with COMMIT in the SQL standard.