COMMIT Statement (commit_statement) 

A COMMIT statement ( commit_statement) terminates the current transaction and starts a new one (see transactions).

Syntax

<commit_statement> ::= COMMIT [WORK]

lock_statement

Explanation

The commit statement terminates the current transaction. This means that the modifications executed within the transaction are recorded and are thus visible to concurrent users as well. The locks assigned to the transaction are released.

The COMMIT statement implicitly opens a new transaction. Any locks set within the new transaction are assigned to this transaction. The setting of locks in the new transaction is controlled by the isolation level declared in the CONNECT statement (see Isolation Level).