MAXERROR
Purpose
Designates a maximum error severity level beyond which BTEQ terminates job processing.
Syntax
where:
Syntax Element |
Specification |
n |
The error severity level at which BTEQ terminates. |
Usage Notes
If a BTEQ script contains a Teradata SQL statement that produces an error severity level greater than the designated MAXERROR value, BTEQ immediately aborts. Therefore, to have BTEQ exit on an error severity level of 8, set MaxErrorLevel to 7.
If MAXERROR has not been specified, the automatic termination feature is disabled and the BTEQ job continues to execute until BTEQ encounters one of the following conditions:
Note: For more information on I/O errors and abends, refer to “I/O Errors and Abends” on page 95. For more information about error severity levels, see “ERRORLEVEL” on page 149.