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) |
|---|---|
| Category: | Bulk Loading |
| Default: | YES |
| Restriction: | This option is valid only when using the TPT API. |
| Requirement: | To use this option, you must first specify TPT=YES. |
| Data source: | Teradata |
| Note: | The default for this option changed from NO to YES in SAS 9.4M9. |
| 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,TPT_TRACE_LEVEL= data set option, TPT_TRACE_LEVEL_INF= data set option, TPT_TRACE_OUTPUT= data set option |
Table of Contents
specifies that the maximum possible number of statements be packed into Multi-Statement insert requests when using the TPT API.
specifies that the default number of statements be packed into Multi-Statement insert requests when using the TPT API.
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.