UPDATE_MULT_ROWS= LIBNAME Option

Indicates whether SAS updates multiple rows from a data source, such as a DBMS table.
Valid in: SAS/ACCESS LIBNAME statement
Default: NO
Data source: Aster nCluster, Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Sybase IQ
See: DELETE_MULT_ROWS= LIBNAME option

Syntax

UPDATE_MULT_ROWS=YES | NO

Syntax Description

YES
specifies that SAS/ACCESS processing continues if multiple rows are updated. This might produce unexpected results.
NO
specifies that SAS/ACCESS processing does not continue if multiple rows are updated.

Details

Some providers do not handle this DBMS SQL statement well and therefore update more than the current row with this statement:
UPDATE…WHERE CURRENT OF CURSOR
UPDATE_MULT_ROWS= lets SAS/ACCESS continue if multiple rows were updated.