Specifies whether to use the TPT load operator.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS) |
|---|---|
| Category: | Bulk Loading |
| Default: | NO |
| Data source: | Teradata |
| See: | BULKLOAD= LIBNAME option, BULKLOAD= data set option, DBSLICEPARM= LIBNAME option, DBSLICEPARM= data set option, DBSLICEPARM= system option, FASTLOAD= LIBNAME option , LOGDB= LIBNAME option, FASTEXPORT= LIBNAME option , Maximizing Teradata Load Performance, MULTILOAD= data set option, QUERY_BAND= LIBNAME option, QUERY_BAND= data set option, SLEEP= LIBNAME option, SLEEP= data set option, TENACITY= LIBNAME option, TENACITY= data set option, TPT= data set option, TPT= LIBNAME option, TPT_DATA_ENCRYPTION= data set option, TPT_DATA_ENCRYPTION= LIBNAME option, TPT_UNICODE_PASSTHRU= LIBNAME option |
Table of Contents
specifies that SAS/ACCESS uses the TPT load operator to load data.
specifies that SAS/ACCESS does not use the TPT load operator to load data.
The FASTLOAD= data set option uses the TPT API to efficiently load data into an empty Teradta table. SAS/ACCESS creates the target table. For more information, see Maximizing Teradata Load and Read Performance.
You can specify FASTLOAD= by using a data set option or LIBNAME option. The disadvantage of using the LIBNAME option is that, whenever you insert data from SAS into Teradata tables in the SAS library, the TPT FastLoad protocol is used. This takes Teradata utility slots, which might also cause other load jobs to fail.
Specifying the FASTLOAD= data set option on a SAS library hides it from users. In a business intelligence environment, it might be difficult to determine whether this option is specified. If you are setting up SAS libraries that only ETL jobs use, it might be acceptable to use the LIBNAME option.
Teradata on AIX: Beginning with the August 2024 update for SAS/ACCESS on SAS 9.4M8 and with the October 2024 update for SAS/ACCESS on SAS 9.4M7, setting FASTLOAD=NO is ignored. SAS uses the Teradata Parallel Transporter API to load data to Teradata. For more information, see SAS Note 70928 - SAS/ACCESS Interface to Teradata support for Teradata Tools and Utilities (TTU) 17.xx and later in AIX environments.
libname mytera TERADATA server=teraserv user=bob pw=bob1;
/* Create and load a table using a Data step. SAS numeric is */
/* forced to be an INTEGER. */
data mytera.table0 (FASTLOAD=YES DBTYPE= (x= INTEGER));
do x = 1 to 1000000;
output;
end; run;
/* Load an existing table using PROC APPEND. The table must */
/* meet certain requirements. */
PROC SQL;
CONNECT TO TERADATA (USER=bob PW=bob1 SERVER=tera5500);
EXECUTE (DROP TABLE loadThisTable) by TERADATA;
EXECUTE (COMMIT) BY TERADATA;
EXECUTE (CREATE MULTISET TABLE loadThisTable ( a INTEGER , b CHAR(10))
PRIMARY INDEX (a)) by TERADATA;
EXECUTE (COMMIT) BY TERADATA;
QUIT;
DATA work.loadData;
FORMAT b $10.;
a = 1;
output;
b = 'One';
output;
a = 2;
output;
b = 'Two';
output;
a = 3;
output;
b = 'Three';
output;
RUN;
libname mytera teradata server=teraserv user=bob pw=bob1;
PROC APPEND BASE=mytera.loadThisTable (FASTLOAD=YES BL_LOG=BOB_APPEND_ERR)
DATA=work.loadData;
RUN;