Progress
Embedded SQL-92
Guide and Reference
Forced Rollback of a Transaction
The database issues a forced rollback of an active transaction when an ESQL program disconnects from the database or makes an abnormal exit. This forced rollback keeps the database consistent.
When some serious errors occur, a transaction might be implicitly marked for ROLLBACK. This can be detected by the information in the SQLCA. If a transaction is marked for ROLLBACK, no SQL statement can be executed on behalf of that transaction. In such a case, the application must roll back the current transaction before proceeding with execution of the next SQL statement.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |