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
Usage Notes
REPEATSTOP |
Result |
OFF |
If an error occurs for a request that indicates the request cannot be re-tried, BTEQ rolls back to the previous BEGIN statement, and continues inserting records from the point where the error occurred. 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
.SET REPEATSTOP ON;