17.05 - Statement Independence Support - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

Certain forms of Teradata multistatement DML requests support statement independence. Statement independence enables multistatement requests and iterated INSERT statements to roll back only those statements within the transaction or multistatement request that fail.

The client software you are using must support statement independence to prevent all multistatement requests and iterated INSERT statements in a transaction or multistatement request from being rolled back. Refer to the documentation for your client software for information on support for statement independence.
These forms of multistatement requests support statement independence:
  • INSERT; INSERT; INSERT;
  • BT; INSERT; INSERT; ET;
  • BT; INSERT; INSERT;
  • INSERT; INSERT; ET;
  • INSERT; COMMIT;
  • INSERT; INSERT; COMMIT;

Related Information

  • For information about the INSERT statement, see INSERT/INSERT … SELECT.
  • For the rules in regard to using multistatement and iterated requests, see Multistatement and Iterated INSERT Requests.
  • For more information about how transactions are processed and statement independence, see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.