Progress
Embedded SQL-92
Guide and Reference
COMMIT Statement
You can terminate 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. See the "Transaction Isolation Levels" section for more information. The default behavior is that database changes made by one transaction are not visible to any other transaction until you COMMIT the transaction. Once you COMMIT a transaction, the changes you made cannot be canceled.
EXAMPLEThe following example shows a COMMIT statement:
The COMMIT statement does not affect the contents of the host variables or the flow of control in the ESQL program.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |