TD_ERROR_TABLE_2= Table Option

Specifies a name for the second error table.

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

Syntax

TD_ERROR_TABLE_2= name-of-table

Arguments

name-of-table

specifies a name for the error table. The default name for ErrorTable2 is ttname_UV, 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.

Restrictions This option is provided for the Load and Update operators. It is ignored by the Stream operator.
The name of an existing table cannot be used, unless you are restarting a paused job.

Details

ErrorTable2 contains records that violated the unique primary index constraint. This type of error occurs during the application phase of a Load or Update operator job.
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.
For information about the error table format and the procedure to correct errors, see Teradata Parallel Transporter Reference.
Last updated: February 23, 2017