| LIBNAME Statement: 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.
| Restriction: |
Microsoft Access only |
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.
If you assign a value that is greater than INSERTBUFF=1,
SAS notes the indication of success or failure of the insert operation might
be incorrect. The 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 inserting with the VIEWTABLE window, 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/62850/HTML/default/images/cautend.gif)
To assign this option to a group of tables, use the
INSERTBUFF option specified in LIBNAME Options.
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
