Data Set Options for Relational Databases |
Default value: | table_name_RS |
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_LOG_TABLE=valid_teradata_table_name |
specifies the name of the restart log table for SAS to use when using the TPT API to load data with Fastload or MultiLoad.
Details |
To use this option, you must first set TPT=YES. This option is valid only when using the TPT API.
Fastload, MultiLoad, and Multi-Statement insert that use the TPT API require a restart log table. If you do not specify a restart log table, Teradata appends "_RS" to the name of the target table to load and uses it as the restart log table by default. You can override this name by setting TPT_LOG_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_LOG_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 restart log table that Multi-Statement uses with the TPT API.
libname tera teradata user=testuser pw=testpw; /* Load using Fastload TPT. Use alternate names for the log table. */ data tera.testdata(MULTISTMT=YES TPT_LOG_TABLE=restarttab); 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_WORK_TABLE= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.