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
represent information for only 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=
is 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.