UPDATE_SQL= Data Set Option

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

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	LIBNAME setting
Data source:	Microsoft SQL Server, ODBC
See:	INSERT_SQL= data set option, UPDATE_SQL= LIBNAME option

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.