Specifies whether SAS uses the Teradata Parallel Transporter (TPT) API to load data when SAS requests a Fastload, MultiLoad, or Multi-Statement insert.
Table of Contents
specifies that SAS uses the TPT API when Fastload, MultiLoad, or Multi-Statement insert is requested.
specifies that SAS does not use the TPT API when Fastload, MultiLoad, or Multi-Statement insert is requested.
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=YES (the default), SAS uses the TPT API load driver for FastLoad, the update driver for MultiLoad, the TPT Export driver for FastExport, and the stream driver for Multi-Statement insert.
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=myusr1 pw=mypwd1 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;