TD_ERROR_TABLE_1= Table Option

Specifies a name for the first error table.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within the BULKLOAD= Table Option
Data source: Teradata
Syntax
Arguments
Details
See Also

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.

See Also

Table Options:
BULKLOAD= Table Option
TD_DROP_ERROR_TABLE= Table Option
TD_LOGDB= Table Option
Copyright © SAS Institute Inc. All rights reserved.