ANSI Transaction-semantics are supported for Teradata Database for UNIX version 2 release 2 (or later). If ANSI Transaction-semantics are used, 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.