| The LIBNAME Statement for PC Files on Microsoft Windows |
Specifies the number of rows in a single insert.
| Valid in: |
DATA and PROC steps (when accessing PC files
data using SAS/ACCESS software)
|
| Default value: |
LIBNAME option setting
|
|
INSERTBUFF=number-of-rows
|
-
number-of-rows
-
specifies the number of rows to insert.
The value must be a positive integer.
SAS allows the maximum number of rows
that is allowed by the data source. The optimal value for this option varies
with factors such as network type and available memory. You might 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 might 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 data source
interface from trying to insert multiple rows. These features do not support
inserting more than one row at a time. ![[cautionend]](../../../../common/61925/HTML/default/images/cautend.gif)
To assign this option to a group of tables, use the
INSERTBUFF= option specified in LIBNAME Options for PC Files on Microsoft Windows.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
