Data Set Options for Relational Databases |
Default value: | table_name_UV |
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_ERROR_TABLE_2=valid_teradata_table_name |
specifies the name of the second error 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 and MultiLoad require an error table to hold records that were rejected during the acquisition phase. If you do not specify an error table, Teradata appends "_UV" to the name of the target table to load and uses it as the second error table by default. You can override this name by setting TPT_ERROR_TABLE_2=. If you do this and the load step fails, you must specify the same name when restarting. For information about errors that are logged in this table, see your Teradata documentation.
The name that you specify in TPT_ERROR_TABLE_2= 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 both the first and second error tables that Fastload and MultiLoad use with the TPT API.
libname tera teradata user=testuser pw=testpw; /* Load using Fastload TPT. Use alternate names for the error tables. */ data tera.testdata(FASTLOAD=YES TPT_ERROR_TABLE_1=testerror1 TPT_ERROR_TABLE_2=testerror2); i=1;output; i=2;output; run;
See Also |
Maximizing Teradata Load Performance
TPT_ERROR_TABLE_1= Data Set Option
TPT_LOG_TABLE= Data Set Option
TPT_WORK_TABLE= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.