 |
|
| Data Set Options for Relational Databases |
TPT_PACKMAXIMUM= Data Set Option
Specifies the maximum possible number of statements to pack into Multi-Statement insert requests when using the TPT API.
| Default value: | NO |
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
| DBMS support: | Teradata |
| Syntax | |
| Syntax Description | |
| See Also |
Syntax |
| TPT_PACKMAXIMUM=integer |
Syntax Description
- YES
-
specifies the maximum possible pack factor to use.
- NO
-
specifies that the default pack factor is used.
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
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.