Data Set Options for Relational Databases |
Specifies the number of shared
memory buffers to use for transferring
data from SAS to Teradata.
Default value: |
2
|
Valid in: |
DATA and PROC steps (when creating and appending
to DBMS tables using SAS/ACCESS software)
|
DBMS support: |
Teradata
|
BUFFERS=number-of-shared-memory-buffers
|
- number-of-shared-memory-buffers
-
a numeric value between 1 and 8 that specifies the number
of buffers used for transferring data from SAS to Teradata.
BUFFERS= specifies the number of data buffers to use for transferring
data from SAS to Teradata. When you use the MULTILOAD= data set option, data
is transferred from SAS to Teradata using shared memory segments. The default
shared memory buffer size is 64K. The default number of shared memory buffers
used for the transfer is 2.
Use BUFFERS= to vary the number of buffers for data transfer from 1
to 8. Use the MBUFSIZE= data set option to vary the size of the shared memory
buffers from the size of each data row up to 1MB.
For more information about specifying the size of shared memory buffers,
see the
MBUFSIZE= Data Set Option.
MULTILOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.