TD_ERROR_TABLE_1= Table Option

Specifies a name for the first error table.

Category: Bulk Loading
Requirement: Must be specified within the BULKLOAD= Table Option
Data source: Teradata

Syntax

TD_ERROR_TABLE_1= name-of-table

Arguments

name-of-table

specifies a name for the error table. The default name for ErrorTable1 is ttname_ET, where ttname is the name of the target table. Table names exceeding 27 characters are truncated to accommodate the three-character suffix. Therefore, you might want to specify a name for the table that will not be truncated. When truncation occurs, a message is written to the log.

Restriction The name of an existing table cannot be used, unless you are restarting a paused job.

Details

ErrorTable1 contains records that were rejected during the acquisition phase of a Load, Stream, or Update operator job because of the following:
  • Data conversion errors
  • Constraint violations
  • Access Module Processor (AMP) configuration changes.
The error table is created in the default user (logon) database, optionally qualified with a schema, unless the TD_LOGDB= table option is used to specify a different location for utility tables.
Error tables that contain errors are retained at the end of a job. Specify the TD_DROP_ERROR_TABLE= table option if you do not want to retain them.
For information about the error table format and the procedure to correct errors, see Teradata Parallel Transporter Reference.
Last updated: February 23, 2017