Specifies the number of rows that are processed in a single DBMS Update or Delete operation.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | LIBNAME option value |
| Data source: | Oracle |
| See: | UPDATEBUFF= LIBNAME option |
Table of Contents
is the maximum value that is allowed by the DBMS.
When updating with the VIEWTABLE window or PROC FSVIEW, use UPDATEBUFF=1 to prevent the DBMS interface from trying to update multiple rows. By default, these features use record-level locking and update only one observation at a time. They lock only the observation that is currently being edited.