Error Handling | Basic Teradata Query - 17.00 - Error Handling - 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

This section describes the BTEQ error handling process, and the changes needed to meet specific requirements. BTEQ error handling involves the following elements:

Element Definition
Database error codes Produced by a database in response to SQL statements that the user executes.
BTEQ return codes Produced by BTEQ to indicate the completion status of a task or job step.
Error severity levels User-assigned values that extend the capability of return codes.
Maximum error level MAXERROR is a user-assigned value that specifies the error severity level at which BTEQ terminates job processing.
Stored procedure compilation errors Syntax and semantic errors in the stored procedure source text reported by the database as part of the SUCCESS or OK parcel.