- Execution of the first SQL request in a session.
- Execution of the first request following the close of a previous transaction.
Transactions close when the application performs a COMMIT, ROLLBACK, or ABORT request.
When the transaction contains a DDL statement (including DATABASE and SET SESSION, which are considered DDL statements in this context), the statement must be the last request in the transaction before the transaction closing statement.
A session executing under ANSI transaction semantics does not allow the BEGIN TRANSACTION statement, END TRANSACTION statement, or two-phase commit protocol. Submitting these statements in ANSI mode is an error.
- Results in a deadlock.
- Performs a DDL statement that stops.
- Executes an explicit ROLLBACK or ABORT statement.
Vantage accepts the ABORT and ROLLBACK statements (including their conditional forms) in ANSI mode. If the system detects an error for either a single or multistatement request, it rolls back only that request, and the transaction remains open, except in special circumstances.
Application-initiated, asynchronous stops cause full transaction rollback in ANSI mode.