188 DBSLICEPARM= Data Set Option Chapter 10
proc reg SIMPLE
data=lib.customers(DBSLICE="UPPER(GENDER)=’M’" "UPPER(GENDER)=’F’"));
var age weight;
where years_active>1;
run;
The following example partitions on the non-null column CHILDREN, the number of
children in a family. Three read threads are created.
data local;
set lib.families(DBSLICE=("CHILDREN<2" "CHILDREN>2" "CHILDREN=2"));
where religion="P";
run;
DBSLICEPARM= Data Set Option
Controls the scope of DBMS threaded reads and the number of DBMS connections
Valid in: SAS configuration file option, SAS invocation option, global SAS option,
LIBNAME option, or dataset option
DBMS support: DB2 UNIX/PC, ODBC, Oracle, SYBASE, Teradata
Default value: THREADED_APPS, 2 (Oracle,Teradata,) THREADED_APPS, 3 (DB2
UNIX/PC, ODBC, SYBASE)
Syntax
DBSLICEPARM=NONE | THREADED_APPS |ALL
DBSLICEPARM=( NONE | THREADED_APPS |ALL <, max-threads>)
Syntax Description
Two syntax diagrams are shown here in order to highlight the simpler version. In
most cases, the simpler version suffices.
NONE
disables DBMS threaded reads. SAS reads tables on a single DBMS connection,
identically to SAS Version 8.
THREADED_APPS
makes fully threaded SAS procedures (threaded applications) eligible for threaded
reads.
ALL
makes all read-only librefs eligible for threaded reads. This includes SAS threaded
apps, as well as the SAS data step and numerous SAS procedures.
max-threads
specifies with a positive integer value the maximum number of connections per table
read. A partition or portion of the data is read on each connection. The combined
rows across all partitions are the same irrespective of the number of connections.
That is, changes to the number of connections do not change the result set.
