Data Set Options for Relational Databases

TPT= Data Set Option

Specifies whether SAS uses the TPT API to load data for Fastload, MultiLoad, or Multi-Statement insert requests.

Default value:	YES
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=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

To use this option, you must first set BULKLOAD=YES.

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 is requested. SAS still tries to load data even if it cannot use the TPT API.

libname tera Teradata user=testuser pw=testpw;
/* Create data */
data testdata;
do i=1 to 100;
	output;
end;
run;
/* Load using FastLoad TPT.  This note appears in the SAS log if SAS uses TPT.
NOTE:  Teradata connection:  TPT FastLoad has inserted 100 row(s).*/
data tera.testdata(FASTLOAD=YES TPT=YES);
set testdata;
run;

See Also

To assign this option to a group of relational DBMS tables or views, see the TPT= LIBNAME 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