TPT_WORK_TABLE= Data Set Option

Specifies the name of the work table for SAS to use when using the TPT API with MultiLoad.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	table_name_WT
Data source:	Teradata
See:	Maximizing Teradata Load Performance , Using the TPT API , MULTILOAD= data set option , TPT= LIBNAME option, TPT= data set option, TPT_ERROR_TABLE_1= data set option, TPT_ERROR_TABLE_2= data set option, TPT_LOG_TABLE= data set option

Syntax

Details

Example

Syntax

TPT_WORK_TABLE=valid_teradata_table_name

Syntax Description

valid_teradata_table_name: specifies the name of the work table for SAS to use when using the TPT API to load data with MultiLoad.

Details

To use this option, you must first set TPT=YES. This option is valid only when using the TPT API.

MultiLoad inserts that use the TPT API require a work table. If you do not specify a work table, Teradata appends "_WT" to the name of the target table to load and uses it as the work table by default. You can override this name by setting TPT_WORK_TABLE=. If you do this and the load step fails, you must specify the same name when restarting.

The name that you specify in TPT_WORK_TABLE= must be unique. It cannot be the name of an existing table unless it is in a restart scenario.

Example: Specify a Different Name for the Work Table

In this example, a different name is provided for the work table that MultiLoad uses with the TPT API.

libname tera teradata user=testuser pw=testpw;
/* Load using Multiload TPT.  Use alternate names for the work table. */
data tera.testdata(MULTILOAD=YES TPT_WORK_TABLE=worktab);
i=1;output; i=2;output;
run;