TPT_PACK= Data Set Option

Specifies the number of statements to pack into a Multi-Statement insert request when using the TPT API.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Category: Bulk Loading
Default: 20
Restrictions: The maximum value is 600. See your Teradata documentation for details.
This option is valid only when using the TPT API.
Requirement: To use this option, you must first specify TPT=YES.
Data source: Teradata
See: Maximizing Teradata Load Performance, Using the TPT API, MULTISTMT= data set option, TPT= LIBNAME option, TPT= data set option, TPT_PACKMAXIMUM= data set option

Table of Contents

Syntax

TPT_PACK=integer

Syntax Description

integer

specifies the number of statements to pack into a Multi-Statement insert request when using the TPT API.

Last updated: February 3, 2026