134 UPDATEBUFF= LIBNAME Option Chapter 9
UPDATEBUFF= LIBNAME Option
Specifies the number of rows that are processed in a single DBMS update or delete operation
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support:
Oracle
Default value:
1
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 (because by default they
use record-level locking; they lock only the observation that is currently being edited).
See Also
To apply this option to an individual data set, see the data set option
“UPDATEBUFF= Data Set Option” on page 217.
USE_ODBC_CL= LIBNAME Option
Indicates whether the Driver Manager uses the ODBC Cursor Library
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: ODBC, Microsoft SQL Server
Default value: NO
Syntax
USE_ODBC_CL= YES | NO
Syntax Description
