INSERT_SQL

Determines the method to use to insert rows into a data source.
Valid in: DATA and PROC steps
Default: LIBNAME option setting

Syntax

INSERT_SQL=YES | NO

Syntax Description

YES
specifies that the SAS/ACCESS engine uses the data source's SQL insert method to insert new rows into a table.
NO
specifies that the SAS/ACCESS engine uses an alternate (data source-specific) method to add new rows to a table.

See Also

To assign this option to a group of tables, use the INSERT_SQL= option specified in LIBNAME Options.