The LIBNAME Statement for Relational Databases |
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
|
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.