The LIBNAME Statement for Relational Databases

UPDATE_SQL= LIBNAME Option

Determines the method that is used to update and delete rows in a data source.

Default value:	YES (except for the Oracle drivers from Microsoft and Oracle)
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Microsoft SQL Server, ODBC

Syntax
Syntax Description
Details
See Also

Syntax

UPDATE_SQL=YES | NO

Syntax Description

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() application programming interface (API) to update or delete rows in a table.

Details

This is the update/delete equivalent of the INSERT_SQL= LIBNAME option. The default for the Oracle drivers from Microsoft and Oracle is NO because these drivers do not support Current-Of-Cursor operations.