All data sources default
to INSERT_SQL=YES except for SAS data sets. When INSERT_SQL=YES, INSERTBUFF=
defaults to 1 and single row inserts are used. 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.
The SAS application
messages that indicate the success or failure of an insert operation
only represent information for a single insert, even when multiple
inserts are performed. Therefore, when you assign a value that is
greater than INSERTBUFF=1, these messages might be incorrect.
If you specify the DBCOMMIT=
option with a value that is less than the value of INSERTBUFF=, then
DBCOMMIT= overrides INSERTBUFF=. If neither DBCOMMIT= nor INSERTBUFF=
are specified, INSERTBUFF= defaults to a block size of 32K. SAS determines
the number of rows by dividing 32K by the size of each row.
Note: When you insert by using
the
VIEWTABLE window or the FSVIEW or FSEDIT
procedure, use INSERTBUFF=1 to prevent the DBMS driver from trying
to insert multiple rows. These features do not support inserting more
than one row at a time.
Additional driver-specific
restrictions might apply.