Error Severity Levels | Basic Teradata Query - Error Severity Levels - Basic Teradata Query

As described in BTEQ Return Codes, the default return code assignments for database error messages also determine the ERRORLEVEL status value that can be used in subsequent testing and branching commands, such as:

SELECT * FROM SOMEWHERE;
.IF ERRORLEVEL >= 14 THEN .QUIT 17;

The ERRORLEVEL command can also be used to change the severity level associated with one or more error codes, as in the following example:

.SET ERRORLEVEL 2168 SEVERITY 4,
       (2173, 3342, 5262) SEVERITY 8
.SET ERRORLEVEL UNKNOWN SEVERITY 16