TD_WORK_TABLE= Table Option

Specifies a name for the TPT Work table.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified with the BULKOPTS= Table Option
Data source: Teradata

Syntax

TD_WORK_TABLE= name-of-table

Arguments

name-of-table

specifies a name for the TPT Work table. The default name for the table is ttname_WT, 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 This option is provided for the Update operator. It is ignored by the Load and Stream operators.

Details

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