Determines the method that is used to update and delete rows in a data source.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | YES [except for the Oracle drivers from Microsoft and Oracle] |
| NO [Oracle drivers from Microsoft and Oracle, which do not support Current-of-Cursor operations] | |
| Data source: | DB2, Greenplum, HAWQ, Microsoft SQL Server, ODBC, Vertica |
| Notes: | Support for HAWQ was added in SAS 9.4M3. |
| Support for DB2 was added in SAS 9.4M9. | |
| See: | INSERT_SQL= LIBNAME option, UPDATE_SQL= data set option |
Table of Contents
specifies that SAS/ACCESS uses Current-of-Cursor SQL to update or delete rows in a table.
specifies that SAS/ACCESS uses the SQLSetPos() application programming interface (API) to update or delete rows in a table.
This is the equivalent of update or delete for the INSERT_SQL= LIBNAME option. The default for Oracle drivers from Microsoft and Oracle is NO because these drivers do not support Current-Of-Cursor operations.