Show TOC

Background documentationCOMMIT Statement (commit_statement)

 

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

Structure

Syntax Syntax

  1. <commit_statement> ::=
  COMMIT [WORK]
End of the code.
Explanation

The COMMIT statement terminates the current transaction and 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 defined in the CONNECT statement.

More Information

Glossary, COMMIT