COMMIT

COMMIT

Syntax

commit ::=

Description

The COMMIT statement explicitly commits the current transaction to the database. This statement is useful when AUTOCOMMIT mode has been set to FALSE.

WORK

The WORK keyword ensures compliance with standard SQL.

FORCE global_tx_id

In an XA environment, a transaction can be forcefully committed even when it is in an "in-doubt" state.

global_tx_id is a character string that consists of the format identifier, the global transaction ID, and the branch qualifier of the global transaction.

Restriction

This statement cannot be executed in AUTOCOMMIT mode.

Example

The following statement applies the result of all of the transaction's previously executed commands to the database.

iSQL> COMMIT;
Commit success.