Managing Transactions in ESQL

The way Progress handles transaction processing differs between ESQL and Progress/SQL. Progress/SQL uses the same block-oriented transaction management model as the Progress 4GL. However, in Embedded SQL, a transaction begins when you call sqllogin() and continues until you execute one of these statements:

You can include COMMIT WORK and ROLLBACK WORK statements anywhere in your application. Use the COMMIT WORK and ROLLBACK WORK statements frequently since all updated rows are locked until one of these statements is encountered. See the esqldemo.cc and dyndemo.cc sample applications provided with your installation for information on how the COMMIT WORK and ROLLBACK WORK statements are used in ESQL.

NOTE: If you call sqllogout() before committing the current transaction, the transaction is rolled back.


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