| Data Set Options for Relational Databases |
Specifies the number of bulk rows that the
SAS/ACCESS engine
can buffer for output.
| Default value: |
100
|
| Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
| DBMS support: |
Sybase
|
|
BULK_BUFFER=numeric-value
|
-
numeric-value
-
is the maximum number of rows that are allowed.
This value depends on the amount of memory that is available to your system.
This option improves performance by specifying
the number of rows that can be held in memory for efficient retrieval from
the DBMS. A higher number signifies that more rows can be held in memory and
accessed quickly during output operations.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
