You can complete a transaction in an application by using the COMMIT statement. When a COMMIT statement is executed, all the changes made to the database by the transaction are made permanent.
Depending on the isolation level of the transaction, changes made by one transaction might not be visible to other transactions before the transaction is committed. OpenEdge SQL's default behavior is to make database changes visible only after the transaction has been committed.
The COMMIT statement uses the following syntax:
COMMIT [ WORK ];
The following example shows a COMMIT statement:
COMMIT WORK ;
Note: The COMMIT statement does not affect the contents of the host variables or the flow of control in the program.
For more on the COMMIT statement, see OpenEdge Data Management: SQL Reference.
