Progress
Embedded SQL-92
Guide and Reference
Starting a Transaction
The database implicitly starts a transaction with the first executable SQL statement in an ESQL program. When an active transaction exists, a subsequent executable SQL statement does not begin a new transaction.
EXAMPLEIn the following code fragment, a new transaction begins when the database executes the CREATE TABLE statement. Executing the INSERT statement does not start a new transaction since an active transaction already exists:
NOTE: Declarative statements do not start a transaction.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |