Show TOC

COMMITLocate this document in the navigation structure

Use

A COMMIT concludes a database transaction. During a COMMIT, the database system saves all the changes carried out by the transaction. The system can no longer use a ROLLBACK to reverse any changes that are completed by a COMMIT.

After a COMMIT, the database system releases all locks that have been allocated to the transaction and implicitly opens a new transaction.

Table 1: AUTOCOMMIT Mode

ON

The database system performs all the necessary COMMIT actions automatically.

OFF

You have to enter COMMIT commands explicitly.

More Information