Specifies the block size in bytes for TPT Export.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Bulk Loading |
| Default: | Varies (see Details) |
| Range: | Varies (see Details) |
| Data source: | Teradata |
| Note: | Support for this data set option was added in SAS Viya 3.5. |
Table of Contents
specifies the block size in bytes when running TPT Export.
Using this option can improve performance when transferring data.
The value that you specify cannot be larger than the message size that is supported by your Teradata DBMS. If the value that you specify is too large, SAS/ACCESS automatically resets the value to the maximum that is allowed for a block size and the job continues.
The default value for TPT_BLOCK_SIZE= varies, based on your Teradata version.
|
Version |
Default |
Range |
|---|---|---|
|
Teradata 15.10 and earlier |
64330 |
256–64330 |
|
Teradata 16.00 and later |
16775168 |
256–16775168 |