Handling Errors - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.