The LIBNAME Statement for Relational Databases

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.

Default value:	YES
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Teradata

Syntax
Syntax Description
Details
Example
See Also

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

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;

See Also

To apply this option to an individual data set, see the TPT= Data Set Option.

Maximizing Teradata Load Performance

Using the TPT API

BULKLOAD= LIBNAME Option

BULKLOAD= Data Set Option

MULTILOAD= Data Set Option

MULTISTMT= Data Set Option

TPT_APPL_PHASE= Data Set Option

TPT_BUFFER_SIZE= Data Set Option

TPT_CHECKPOINT_DATA= Data Set Option

TPT_DATA_ENCRYPTION= Data Set Option