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
greater than INSERTBUFF=1, the SAS notes indicating success or failure
of the insert operation might be incorrect. These notes are generated
for a single insert. This is also true, when multiple inserts are
performed.
Note: PC Files Server does not
support INSERTBUFF= option with a value higher than 1 for writing
data to Excel. It ignores this option when writing data to Excel.
If the DBCOMMIT= option
is specified with a value that is less than the value of INSERTBUFF=,
then DBCOMMIT= overrides INSERTBUFF= option.
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.