Previous Page
|
Next Page
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
n
Cluster, Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Sybase IQ
See:
DELETE_MULT_ROWS= LIBNAME option
Syntax
Details
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.
Copyright © SAS Institute Inc. All rights reserved.
Previous Page
|
Next Page
|
Top of Page