Background documentationCOMMIT Locate this document in the navigation structure

 

A COMMIT concludes a transaction. When a COMMIT is executed, 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.

AUTOCOMMIT Mode

ON

The database system performs all the necessary COMMIT actions automatically.

OFF

You have to enter COMMIT commands explicitly.

More Information