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; all other data sources, the default
is YES.
|
| Supports: |
All |
Syntax
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.