Data Set Options for Relational Databases |
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
|
UPDATEBUFF=positive-integer
|
- positive-integer
-
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 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).
To assign this option to a group of relational DBMS tables
or views, see the UPDATEBUFF= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.