98 DEGREE= LIBNAME Option Chapter 9
See Also
“CONNECTION= LIBNAME Option” on page 78
DEGREE= LIBNAME Option
Determines whether DB2 uses parallelism
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
DB2 OS/390
Default value:
ANY
Syntax
DEGREE= ANY | 1
Syntax Description
ANY
enables DB2 to use parallelism, and issues the SET CURRENT DEGREE =’xxx’ for
all DB2 threads that use that libref.
1
explicitly disables the use of parallelism.
Details
When DEGREE=ANY, DB2 has the option of using parallelism, when it is appropriate.
Setting DEGREE=1 prevents DB2 from performing parallel operations. Instead,
DB2 is restricted to performing one task that, while perhaps slower, uses less system
resources.
DELETE_MULT_ROWS= LIBNAME Option
Indicates whether to allow SAS to delete multiple rows from a data source, such as a DBMS table
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: ODBC, OLE DB, Microsoft SQL Server
Default value: NO
Syntax
DELETE_MULT_ROWS=YES | NO
Syntax Description
