The LIBNAME Statement for Relational Databases UPDATE_SQL= LIBNAME Option 133
specifies that SAS/ACCESS processing continues if multiple rows are updated. This
may produce unexpected results.
NO
specifies that SAS/ACCESS processing does not continue if multiple rows are
updated.
Details
Some providers do not handle the following DBMS SQL statement well, and therefore
update more than the current row with this statement:
UPDATE ... WHERE CURRENT OF CURSOR
UPDATE_MULT_ROWS= enables SAS/ACCESS to continue if multiple rows were
updated.
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
DBMS support:
ODBC, Microsoft SQL Server
Default value:
YES (except for the Oracle drivers from Microsoft and Oracle)
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= option. The default for the
Oracle drivers from Microsoft and Oracle is NO because these drivers do not support
Current-Of-Cursor operations.
See Also
To apply this option to an individual data set, see the data set option
“UPDATE_SQL= Data Set Option” on page 216.
