Indicates whether SAS updates multiple rows from a data source, such as a DBMS table.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | NO |
| Requirement: | Snowflake: To use DELETE or UPDATE statements for multiple rows in a table, the table must have a primary key, and the data for the primary key must be unique. Otherwise, you must set the UPDATE_MULT_ROWS= LIBNAME option to YES. |
| Data source: | Aster, Greenplum, HAWQ, Impala, Microsoft SQL Server, ODBC, OLE DB, SAP HANA, SAP IQ. Snowflake, Vertica, Yellowbrick |
| Note: | Support for Yellowbrick was added in SAS 9.4M7. |
| See: | DELETE_MULT_ROWS= LIBNAME option |
Table of Contents
specifies that SAS/ACCESS processing continues if multiple rows are updated. This might produce unexpected results.
specifies that SAS/ACCESS processing does not continue if multiple rows are updated.
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 CURSORUPDATE_MULT_ROWS= allows SAS/ACCESS to continue if multiple rows were updated.