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.