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. |