Data Set Options for Relational Databases BULKLOAD= Data Set Option 165
BULK_BUFFER= Data Set Option
Specifies the number of bulk rows that the SAS/ACCESS engine can buffer for output
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
SYBASE
Default value:
100
Syntax
BULK_BUFFER=numeric-value
Syntax Description
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.
Details
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.
BULKLOAD= Data Set Option
Loads rows of data as one unit
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 OS/390, DB2 UNIX/PC, Oracle, SYBASE, Teradata
Default value:
NO
Syntax
BULKLOAD=YES | NO
Syntax Description
YES
calls a DBMS-specific bulk load facility in order to insert or append rows to a DBMS
table.
NO
