How to Disable the Retry Function | Basic Teradata Query - 17.00 - Disabling the Retry Function - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

By default, the BTEQ request retry function (RETRY command) is enabled. This automatically resubmits requests that fail because of certain error conditions.

Use the BTEQ RETRY command to disable the retry function before submitting requests that are embedded in either an explicit transaction, a multi-statement request, or an executing BTEQ macro.

For Teradata transaction semantics mode, explicit transactions begin with a BEGIN TRANSACTION statement and end with an END TRANSACTION statement. Multi-statement requests and executing BTEQ macros are treated as implicit transactions.