UPDATEBUFF= Data Set Option

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)
Default: LIBNAME setting
Data source: Oracle
See: UPDATEBUFF= LIBNAME option

Syntax

UPDATEBUFF=positive-integer

Syntax Description

positive-integer
is the maximum value that is allowed by the DBMS.

Details

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 update only one observation at a time (since by default they use record-level locking, they lock only the observation that is currently being edited).