TPT_BUFFER_SIZE= Data Set Option

Specifies the output buffer size in kilobytes when SAS sends data to Teradata with Fastload or MultiLoad using the TPT API.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: 64
Data source: Teradata
See: Maximizing Teradata Load Performance , Using the TPT API , BULKLOAD= LIBNAME option, BULKLOAD= data set option, TPT= LIBNAME option, TPT= data set option

Syntax

TPT_BUFFER_SIZE=integer

Syntax Description

integer
specifies the size of data parcels in kilobytes from 1 through 64.

Details

To use this option, you must first set TPT=YES.
You can use the output buffer size to control the amount of data that is transferred in each parcel from SAS to Teradata when using the TPT API. A larger buffer size can reduce processing overhead by including more data in each parcel. See your Teradata documentation for details.