Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## COMMIT

> Commits a transaction explicitly after executing one or more SQL statements. Committing a transaction makes permanent any changes made by the SQL statements.

> #### Syntax

>     COMMIT [ WORK ] ;

> #### Notes

> - The SQL statements executed prior to executing the `COMMIT` statement are executed as one atomic transaction that is recoverable and durable. The transaction is serializable if you specify this isolation level.

> - On a system failure and/or the execution of the `ROLLBACK`, the transaction is rolled back to its initial state. Any changes made by the transaction are undone, restoring the database to its initial state. In the event of a system failure, the transaction will be rolled back during crash recovery when the database is restarted.

> - A `COMMIT` operation makes any database modifications made by that transaction permanent.

> - Once a `COMMIT` operation is executed, the database modifications cannot be rolled back.

> - Once a `COMMIT` operation is executed, the transaction modifications are guaranteed durable regardless of any transient system failures.

> - The atomicity applies only to the database modification and not to any direct I/O performed to devices such as the terminal, printer, and OS files by the application code.

> - A `COMMIT` operation releases all locks implicitly or explicitly acquired by the transaction.

> ##### Related Statement

> ROLLBACK

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095