TPT_PACKMAXIMUM= Data Set Option

Specifies whether to pack the maximum possible or default number of statements into Multi-Statement insert requests when using the TPT API.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	NO
Restriction:	This option is valid only when using the TPT API.
Requirement:	To use this option, you must first set 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_PACK= data set option

Syntax

Details

Syntax

TPT_PACKMAXIMUM=YES | NO

Syntax Description

YES: specifies that the maximum possible number of statements be packed into Multi-Statement insert requests when using the TPT API.

NO: specifies that the default number of statements be packed into Multi-Statement insert requests when using the TPT API.

Details

When TPT_PACKMAXIMUM=YES, the maximum possible number of statements that can fit in a Multi-Statement request is determined dynamically. See your Teradata documentation for details.