Previous Page | Next Page

Data Set Options for Relational Databases

TPT_PACK= Data Set Option



Specifies the number of statements to pack into a Multi-Statement insert request when using the TPT API.
Default value: 20
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Teradata

Syntax
Syntax Description
Details
See Also

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.


See Also

Maximizing Teradata Load Performance

Using the TPT API

MULTISTMT= Data Set Option

TPT= LIBNAME Option

TPT= Data Set Option

TPT_PACKMAXIMUM= Data Set Option

Previous Page | Next Page | Top of Page