This section describes the BTEQ error handling process, and the changes needed to meet specific requirements. BTEQ error handling involves these elements:
Element |
Definition |
Teradata Database error codes |
Produced by a Teradata Database in response to Teradata 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 Teradata Database as part of the SUCCESS or OK parcel. |