Data Set Options for Relational Databases |
Default value: | table_name_WT |
Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
DBMS support: | Teradata |
Syntax | |
Syntax Description | |
Details | |
Example | |
See Also |
Syntax |
TPT_WORK_TABLE=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 |
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;
See Also |
Maximizing Teradata Load Performance
TPT_ERROR_TABLE_1= Data Set Option
TPT_ERROR_TABLE_2= Data Set Option
TPT_LOG_TABLE= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.