Accessing and Using Error Tables
Error tables are automatically generated for the Load, Stream, and Update operators in a Teradata PT job, to provide information on Teradata Database errors encountered while writing data to the Teradata Database. Error tables provide more detailed information about errors initially presented in the job logs. Error tables segregate errors into two groups:
The following operators support error tables:
Operator |
Description |
Load |
Generates acquisition and application error tables (ErrorTable1 and ErrorTable2). Error tables are named in one of the following two ways: TargetTableName_ET TargetTableName_UV |
Update |
|
Stream |
Generates only an acquisition error table (ErrorTable), which is equivalent to ErrorTable1. The Stream operator places the table in the database associated with the job script user logon. The error table is named in one of the following two ways: You can also prefix the name with a database name if the table is to be stored in a different database than the one that contains the target table, using the form: DatabaseName.ErrorTableName
For information chapters on the Load and Update operators in Teradata Parallel Transporter Reference. where: Note: Teradata recommends that you do not use this default error table name. It is a large character string that may lead to data entry errors when accessing the table. |
The content and format of error tables is different for each of these operators. For detailed information the sections beginning with “Load Operator Errors” on page 184.
Consider the following facts about error tables: