Skip to main content

END

Commits the current transaction.

Syntax​

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

Description​

After the current transaction is committed by END, all changes made by the transaction are visible to other users and remain durable if the system crashes.

This statement is equivalent to COMMIT. To terminate a transaction instead of committing it, use ROLLBACK.

When you run END outside a transaction, a warning message will be displayed through the operation has no adverse impact.

Parameters​

  • [WORK | TRANSACTION]

    An additional keyword that has no effect.

  • [AND CHAIN | AND NO CHAIN]

    Whether to start a transaction with the same characteristics immediately after the current transaction ends. Supported options include:

    • AND CHAIN: specifies yes.
    • AND NO CHAIN: specifies no and is the default.

Examples​

Commit the current transaction:

END;

SQL standard compatibility​

END is a Relyt extension. Is is an equivalent to COMMIT in the SQL standard.