iv
Passing Joins to the DBMS 34
When Passing Joins to the DBMS Will Fail
35
Passing DISTINCT and UNION Processing to the DBMS
37
Optimizing the Passing of WHERE Clauses to the DBMS
37
Using the DBINDEX=, DBKEY=, and MULTI_DATASRC_OPT= Options
38
Chapter 6
Threaded Reads 41
Overview of Threaded Reads in SAS/ACCESS
41
Underlying Technology of Threaded Reads
41
SAS/ACCESS Interfaces and Threaded Reads
42
Scope of Threaded Reads
42
Options That Affect Threaded Reads
43
Generating Trace Information for Threaded Reads
44
Performance Impact of Threaded Reads
45
Autopartitioning Techniques in SAS/ACCESS
46
Data Ordering in SAS/ACCESS
47
Two Pass Processing for SAS Threaded Applications
47
Summary of Threaded Reads
47
Chapter 7
How SAS/ACCESS Works 49
Introduction to How SAS/ACCESS Works
49
How the SAS/ACCESS LIBNAME Statement Works
50
How the Pass-Through Facility Works
51
How the ACCESS Procedure Works
51
How the DBLOAD Procedure Works
53
PART2 General Reference 55
Chapter 8
SAS/ACCESS Features by Host 57
Introduction 57
SAS/ACCESS Interface to DB2 UNIX/PC: Supported Features
57
SAS/ACCESS Interface to DB2 OS/390: Supported Features
58
SAS/ACCESS Interface to Informix: Supported Features
58
SAS/ACCESS Interface to Microsoft SQL Server: Supported Features
58
SAS/ACCESS Interface to ODBC: Supported Features
59
SAS/ACCESS Interface to OLE DB: Supported Features
59
SAS/ACCESS Interface to Oracle: Supported Features
60
SAS/ACCESS Interface to Oracle Rdb: Supported Features
60
SAS/ACCESS Interface to SYBASE: Supported Features 61
SAS/ACCESS Interface to Teradata: Supported Features 61
Chapter 9 The LIBNAME Statement for Relational Databases 63
Overview of the LIBNAME Statement for Relational Databases 63
Assigning a Libref Interactively 64
LIBNAME Options for Relational Databases 68
