SAS ACCESS 9.1 Supplement For OLE DB SAS ACCESS For Relational Databases

✍ Scribed by The SAS Technical Team Writers

• Publisher: SAS Institute, Incorporated
• Year: 2004
• Tongue: English
• Leaves: 41
• Category: Library

✦ Synopsis

This supplement describes the SAS/ACCESS features and options that are available for OLE DB. When you use this supplement along with SAS/ACCESS Interface to Relational Databases: Reference, you will have a comprehensive guide to SAS/ACCESS software for your database management system (DBMS). This supplement explains how SAS/ACCESS software has been customized to accommodate the particular requirements and capabilities of your DBMS. This title is also available online. This title is designed for users of SAS/ACCESS software who need specific information about OLE DB. Supports releases 9.1 and higher of SAS software.

✦ Table of Contents

Cover
......Page 1
Contents......Page 4
Introduction to the SAS/ACCESS Interface to OLE DB......Page 6
Arguments......Page 7
Connecting with OLE DB Services......Page 11
OLE DB LIBNAME Statement Examples......Page 12
Data Set Options for OLE DB......Page 13
Pass-Through Facility Specifics for OLE DB......Page 14
Special OLE DB Queries......Page 15
Passing SAS Functions to OLE DB......Page 19
Passing Joins to OLE DB......Page 20
Examples......Page 21
Locking in the OLE DB Interface......Page 23
Overview......Page 24
Using the Pass-Through Facility with OLAP Data......Page 25
Data Types for OLE DB......Page 27
OLE DB Null Values......Page 28
Recommended Reading......Page 30
Glossary......Page 32
Index......Page 38