The COMMIT statement terminates a unit of work and commits the database changes that were made by that unit of work.
Invocation
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
Description
The unit of work in which the COMMIT statement is executed is terminated and a new unit of work is initiated. All changes made by the following statements executed during the unit of work are committed: ALTER, CREATE, DROP, GRANT, LOCK TABLE, REVOKE, and the data change statements (INSERT, DELETE, UPDATE).All locks acquired by the unit of work subsequent to its initiation are released.
Open cursors remain open, and the cursor is positioned before the next logical row of the result set. All LOB locators are freed. Note that this is true even when the locators are associated with LOB values retrieved via a cursor.
All savepoints that were set within the transaction are released.
Notes
Each application process should explicitly end its unit of work before it terminates. If the application program ends normally without a COMMIT or ROLLBACK statement, the database engine will implicitly roll back the last active unit of work.Example
Commit alterations to the database made since the last commit point.COMMIT WORK
