UPDATE_SQL= LIBNAME Option

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

Valid in:	SAS/ACCESS LIBNAME statement
Default:	YES [except for the Oracle drivers from Microsoft and Oracle]
Restriction:	The default for the Oracle drivers from Microsoft and Oracle is NO because these drivers do not support CURRENT OF CURSOR operations.
Data source:	Microsoft SQL Server, ODBC
See:	UPDATE_SQL= data set option, , INSERT_SQL= LIBNAME option

Syntax

Details

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.