Specifies the name of the restart log table for SAS to use when using the TPT API with Fastload, MultiLoad, or Multi-Statement insert.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Bulk Loading |
| Default: | table_name_RS |
| Restriction: | This option is valid only when using the TPT API. |
| Requirement: | To use this option, you must first specify TPT=YES. |
| Data source: | Teradata |
| See: | Maximizing Teradata Load Performance, Using the TPT API, BULKLOAD= LIBNAME option, BULKLOAD= data set option, MULTILOAD= data set option, MULTISTMT= 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_WORK_TABLE= data set option |
Table of Contents
specifies the name of the restart log table for SAS to use when using the TPT API to load data with Fastload or MultiLoad.
To use this option, you must first specify 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 load table and uses it as the restart log table by default. You can override this name by specifying 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.
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=myusr1 pw=mypwd1;
/* 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;