Contents
What’s New vii
Overview vii
All SAS/ACCESS Interfaces to Relational Databases
vii
SAS/ACCESS Interface to DB2 under OS/390
viii
SAS/ACCESS Interface to DB2 under UNIX and PC Hosts
viii
SAS/ACCESS Interface to ODBC
viii
SAS/ACCESS Interface to OLE DB
viii
SAS/ACCESS Interface to Oracle
viii
SAS/ACCESS Interface to SYBASE
ix
SAS/ACCESS Interface to Teradata
ix
PART1 Concepts 1
Chapter 1 Overview of SAS/ACCESS Software for Relational Databases 3
About This Document 3
Methods for Accessing Relational Database Data
3
Selecting a SAS/ACCESS Method
4
SAS Views of DBMS Data
5
Chapter 2
SAS Names and Support for DBMS Names 7
Introduction to SAS/ACCESS Naming
7
SAS Naming Conventions
7
SAS/ACCESS Default Naming Behaviors
9
Options that Affect SAS/ACCESS Naming Behavior
10
Naming Behavior When Retrieving DBMS Data
10
Naming Behavior When Creating DBMS Objects
11
SAS/ACCESS Naming Examples
12
Chapter 3
Data Integrity and Security 21
Introduction to Data Integrity and Security
21
DBMS Security 21
SAS Security 22
Potential Result Set Differences When Processing Null Data
27
Chapter 4
Performance Considerations 29
Increasing Throughput of the SAS Server
29
Limiting Retrieval 29
Repeatedly Accessing Data 30
Sorting DBMS Data 31
Chapter 5 Optimizing Your SQL Usage 33
Overview of Optimizing Your SQL Usage 33
Passing Functions to the DBMS Using PROC SQL 34
