Specifies the number of rows that are processed in a single DBMS Update or Delete operation.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | 1 |
| Data source: | Oracle |
| See: | UPDATEBUFF= data set option |
Table of Contents
the number of rows in an operation. SAS allows the maximum that the DBMS allows.
When updating with the VIEWTABLE window or the FSVIEW procedure, use UPDATEBUFF=1 to prevent the DBMS interface from trying to update multiple rows. By default, these features update only one observation at a time. They do this because they use record-level locking by default and therefore lock only the observation that is currently being edited.