Previous Page | Next Page

Data Set Options for Relational Databases

UPDATEBUFF= Data Set Option



Specifies the number of rows that are processed in a single DBMS update or delete operation.
Default value: LIBNAME setting
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Oracle

Syntax
Syntax Description
Details
See Also

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).


See Also

To assign this option to a group of relational DBMS tables or views, see the UPDATEBUFF= LIBNAME Option.

Previous Page | Next Page | Top of Page