TPT= LIBNAME Option

Specifies whether SAS uses the Teradata Parallel Transporter (TPT) API to load data when SAS requests a Fastload, MultiLoad, or Multi-Statement insert.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	YES
Data source:	Teradata
See:	BULKLOAD= LIBNAME option, BULKLOAD= data set option, LOGDB= LIBNAME option, Maximizing Teradata Load Performance , MULTILOAD= data set option, MULTISTMT= data set option, TPT= data set option, TPT_APPL_PHASE= data set option, TPT_BUFFER_SIZE= data set option, TPT_CHECKPOINT= data set option, TPT_DATA_ENCRYPTION= data set option, TPT_ERROR_TABLE_1= data set option, TPT_ERROR_TABLE_2= data set option, TPT_LOG_TABLE= data set option, TPT_MAX_SESSIONS= data set option, TPT_MIN_SESSIONS= data set option, TPT_PACK= set option, TPT_PACKMAXIMUM= data set option, TPT_RESTART= data set option, TPT_TRACE_LEVEL= data set option, TPT_TRACE_LEVEL_INF= data set option, TPT_TRACE_OUTPUT= data set option, TPT_WORK_TABLE= data set option, Using the TPT API

Syntax

Details

Example

Syntax

TPT=YES | NO

Syntax Description

YES: specifies that SAS uses the TPT API when Fastload, MultiLoad, or Multi-Statement insert is requested.

NO: specifies that SAS does not use the TPT API when Fastload, MultiLoad, or Multi-Statement insert is requested.

Details

By using the TPT API, you can load data into a Teradata table without working directly with such stand-alone Teradata utilities as Fastload, MultiLoad, or TPump. When TPT=NO, SAS uses the TPT API load driver for FastLoad, the update driver for MultiLoad, and the stream driver for Multi-Statement insert.

When TPT=YES, sometimes SAS cannot use the TPT API due to an error or because it is not installed on the system. When this happens, SAS does not produce an error, but it still tries to load data using the requested load method (Fastload, MultiLoad, or Multi-Statement insert). To check whether SAS used the TPT API to load data, look for a similar message to this one in the SAS log.

NOTE: Teradata connection: TPT FastLoad/MultiLoad/MultiStatement 
insert has read n row(s).

Example: Load SAS Data into Teradata

In this example, SAS data is loaded into Teradata using the TPT API. This is the default method of loading when Fastload, MultiLoad, or Multi-Statement insert are requested. SAS still tries to load data even if it cannot use the TPT API.

libname tera teradata user=testuser pw=testpw TPT=YES;
/* Create data */
data testdata;
do i=1 to 100;
	output;
end;
run;

/* Load using MultiLoad TPT.  This note appears in the SAS 
   log if SAS uses TPT.  NOTE:  Teradata connection:  
   TPT MultiLoad has inserted 100 row(s).*/
data tera.testdata(MULTILOAD=YES);
set testdata;
run;