15.10 - ANSI Transaction Semantics - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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.