Data Set Options for Relational Databases

UPDATE_SQL= Data Set Option

Determines which method to use to update and delete rows in a data source.

Default value:	LIBNAME setting
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Microsoft SQL Server, ODBC

Syntax

UPDATE_SQL=YES | NO

YES: specifies that SAS/ACCESS uses Current-of-Cursor SQL to update or delete rows in a table.
NO: specifies that SAS/ACCESS uses the SQLSetPos() API to update or delete rows in a table.

This is the update and delete equivalent of the INSERT_SQL= data set option.

To assign this option to a group of relational DBMS tables or views, see the UPDATE_SQL= LIBNAME Option.