The LIBNAME Statement for Relational Databases |
Indicates
whether to allow SAS to delete 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
|
DELETE_MULT_ROWS=YES | NO
|
-
YES
-
specifies that SAS/ACCESS processing
continues if multiple rows are deleted. This might produce unexpected results.
-
NO
-
specifies that SAS/ACCESS processing
does not continue if multiple rows are deleted.
Some providers do not handle these DBMS
SQL statement well and therefore delete more than the current row:
DELETE ... WHERE CURRENT OF CURSOR
UPDATE_MULT_ROWS= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.