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)
Category: Bulk Loading
Default: 64
Requirement: To use this option, you must first specify TPT=YES.
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

Table of Contents

Syntax

TPT_BUFFER_SIZE=integer

Syntax Description

integer

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

Details

Note: Starting in SAS 9.4M9, the FastLoad and MultiLoad utilities are no longer supported. Documentation remains for users who have not upgraded to SAS 9.4M9.

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.

Last updated: February 3, 2026