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)
Default: 20
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

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.

Details

To use this option, you must first set TPT=YES. This option is valid only when using the TPT API.
The maximum value is 600. See your Teradata documentation for details.