Data Set Options for Relational Databases UPDATEBUFF= Data Set Option 217
Details
This is the update/delete equivalent of the INSERT_SQL= option.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “UPDATE_SQL= LIBNAME Option” on page 133.
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)
DBMS support:
Oracle
Default value:
LIBNAME setting
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 (because 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
LIBNAME option “UPDATEBUFF= LIBNAME Option” on page 134.
