MAXERROR Command | Basic Teradata Query - 17.00 - MAXERROR - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

Purpose

This control enables users to specify a maximum error severity level beyond which BTEQ terminates job processing.

Syntax


MAXERROR syntax

where the following is true:

n
The error severity level at which BTEQ terminates.

Usage Notes

If a BTEQ script contains an 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:
  • End-of-file for the primary command input file
  • A QUIT command
  • A fatal error
    • When BTEQ receives an I/O abend, system error messages appear in the z/OS JES job log.
    • When BTEQ receives an I/O error or an abend, the IBM/C runtime library produces an LSCX message that might contain more information about the error.