Purpose
This control enables users to specify whether a REPEAT operation should terminate if an error occurs for a request that indicates the request cannot be re-tried.
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
| Command | Shorthand |
|---|---|
| REPEATSTOP | RPS |
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.
- ON
- BTEQ terminates the REPEAT operation if an error occurs for a request that indicates the request cannot be re-tried.
The DEFAULTS command resets REPEATSTOP setting to OFF.
The REPEATSTOP command is valid in an SQL macro.
Example – REPEATSTOP
.SET REPEATSTOP ON;