194 INSERTBUFF= Data Set Option Chapter 10
INSERTBUFF= Data Set Option
Specifies the number of rows in a single DBMS insert
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 UNIX/PC, ODBC, OLE DB, Oracle, Microsoft SQL Server
Default value:
LIBNAME setting
Syntax
INSERTBUFF=positive-integer
Syntax Description
positive-integer
specifies the number of rows to insert.
Details
SAS allows the maximum number of rows that is allowed by the DBMS. The optimal
value for this option varies with factors such as network type and available memory. You
may need to experiment with different values to determine the best value for your site.
When you assign a value that is greater than INSERTBUFF=1, the SAS application
notes that indicate the success or failure of the insert operation may be incorrect
because these notes only represent information for a single insert, even when multiple
inserts are performed.
If the DBCOMMIT= option is specified with a value that is less than the value of
INSERTBUFF=, then DBCOMMIT= overrides INSERTBUFF=.
Note: When you are inserting with the VIEWTABLE window or the FSEDIT or
FSVIEW procedure, use INSERTBUFF=1 to prevent the DBMS interface from trying to
insert multiple rows. These features do not support inserting more than one row at a
time.
Note: Additional driver-specific restrictions might apply.
DB2 UNIX/PC Details: You must specify INSERT_SQL=YES in order to use this
option. If one row in the insert buffer fails, all rows in the insert buffer fail.
SQL Server Details: You must specify INSERT_SQL=YES in order to use this option.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “INSERTBUFF= LIBNAME Option” on page 103.
KEYSET_SIZE= Data Set Option
Specifies the number of rows in the cursor that are keyset driven
