Was this helpful?
How Transactions Work
The transaction begins with the first OpenSQL statement following a CONNECT, COMMIT, or ROLLBACK statement, which can be issued by you, the program, or in some instances, by the DBMS.
The transaction continues until there is an explicit COMMIT or ROLLBACK statement or until the session terminates. (Terminating the session or disconnecting from the database normally issues an implicit COMMIT statement. If the session or connection terminates abnormally, the results depend on the host DBMS.)
In Enterprise Access products, transactions are managed by the underlying DBMS. Transaction handling may vary depending on the DBMS to which your session is connected.
For example, some DBMSs begin a transaction immediately following the CONNECT or ROLLBACK statements, rather than awaiting the next OpenSQL statement. For details, see the documentation for the host DBMS.
Last modified date: 01/30/2023