UPDATEBUFF= LIBNAME Option

Specifies the number of rows that are processed in a single DBMS Update or Delete operation.
Valid in: SAS/ACCESS LIBNAME statement
Default: 1
Data source: Oracle
See: UPDATEBUFF= data set option

Syntax

UPDATEBUFF=positive-integer

Syntax Description

positive-integer
the number of rows in an operation. SAS allows the maximum that the DBMS allows.

Details

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.