The LIBNAME Statement for Relational Databases

UPDATE_MULT_ROWS= LIBNAME Option

Indicates whether to allow SAS to update multiple rows from a data source, such as a DBMS table.

Default value:	NO
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Aster nCluster, Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Sybase IQ

Syntax

UPDATE_MULT_ROWS=YES | NO

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.

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.