The LIBNAME Statement for Relational Databases

UPDATEBUFF= LIBNAME Option

Specifies the number of rows that are processed in a single DBMS update or delete operation.

Default value:	1
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Oracle

Syntax
Syntax Description
Details
See Also

Syntax

UPDATEBUFF=positive-integer

Syntax Description

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