In ANSI mode, transactions are implicitly started and explicitly closed.
A transaction initiates when one of the following happens:
- The first SQL statement in a session runs.
- The first statement following the close of a transaction runs.
The COMMIT or ROLLBACK/ABORT statements close a transaction.
These statements are only supported on the Block File System on the primary cluster. They are not available for the Object File System.
A transaction that includes a DDL statement must be the last statement in the transaction. DATABASE and SET SESSION are DDL statements.
If a session terminates with an open transaction, any effects of that transaction are rolled back.
Two-Phase Commit
Sessions in ANSI session mode do not support Two-Phase Commit (2PC). If an attempt is made to use the 2PC protocol in ANSI session mode, the Logon process aborts and an error returns to the requestor.