INSERT_SQL= LIBNAME Statement Option

Specifies the method that is used to insert rows into a data source.

Valid in: LIBNAME statement
Default: NO for SAS data set; for all other data sources, the default is YES.
Supports: All

Syntax

INSERT_SQL= YES | NO

Syntax Description

YES

specifies to use the data source's SQL insert method to insert new rows into a table.

NO

specifies to use an alternate (DBMS-specific) method to insert new rows into a table.

Details

SAS data sets generally have improved insert performance when INSERT_SQL=NO, which is the default for SAS data sets. Other data sources might have inferior insert performance (or might fail) unless INSERT_SQL=YES. You should experiment to determine the optimal setting for your situation.

See Also

To apply this option to an individual table, use the INSERT_SQL= data set option.