Statement Independence Support - Teradata Database

Statement Independence Support

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.

Note: 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;

For More Information

For details on the INSERT statement, see “INSERT/INSERT … SELECT” on page 370.

For details on the rules for using multistatement and iterated requests, see “Rules for Multistatement and Iterated INSERT Requests” on page 383.

For more information about how transactions are processed and statement independence, see SQL Request and Transaction Processing.