REPEATSTOP - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.00
Published
November 2016
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
hyz1479325149183.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

When set to ON, REPEATSTOP terminates a REPEAT operation if an error occurs for a request that indicates the request cannot be re-tried. If REPEATSTOP is set to OFF, REPEAT operations are not aborted.

If the REPEATSTOP command has not been used, its value is OFF by default. If the command is specified, but neither ON or OFF is set, BTEQ sets REPEATSTOP to ON.

Syntax



where the following is true:

OFF
If an error occurs for a request that indicates the request cannot be re-tried, the database rolls back the current transaction and BTEQ continues importing by submitting the next request.

This is the default.

ON
BTEQ terminates the REPEAT operation if an error occurs for a request that indicates the request cannot be re-tried.

Example – REPEATSTOP

.SET REPEATSTOP ON;