ANSI Transaction Semantics - Call-Level Interface Version 2

ANSI Transaction Semantics

If you are using ANSI transaction semantics, the first request begins a transaction implicitly. All subsequent requests are part of the transaction until one of the following events occurs:

SQL COMMIT statement

SQL ROLLBACK statement

LOGOFF statement

Failure response

A failure response rolls back only the statement causing the error unless that error threatens the integrity of the database, in which case the entire transaction is rolled back.