LIBNAME Statement: PC Files on Microsoft Windows |
Sets 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,
the SAS 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 the INSERTBUFF= option, then the DBCOMMIT= option
overrides the INSERTBUFF= option.
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/63294/HTML/default/images/cautend.gif)
LIBNAME Options and
DBCOMMIT
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.