search:
Search support.sas.com
KNOWLEDGE BASE
System Requirements
Install Center
Product Documentation
Papers
Samples & SAS Notes
Focus Areas
SUPPORT
License Assistance
Administrator Services
Downloads & Hot Fixes
LEARNING CENTER
Bookstore
Training
Certification
SAS Learning Edition
Higher Education Resources
SAS OnDemand For Academics
COMMUNITY
User Groups
Events
E-Newsletters
support.sas.com
KNOWLEDGE BASE
SUPPORT
LEARNING CENTER
COMMUNITY
Product Documentation
>
SAS 9.2 Documentation
Print
|
E-mail
|
Bookmark
|
Feedback
SAS(R) 9.2 Providers for OLE DB: Cookbook
PDF
Contents
About
What's New for the SAS 9.2 Providers for OLE DB
Introduction
Introduction to the SAS Providers for OLE DB
About the SAS Providers for OLE DB: Cookbook
About the SAS Providers for OLE DB
Data Sources and File Types Supported by the SAS Providers
Features Supported by the SAS Providers
System Requirements and Installation
System Requirements
SAS Provider for OLE DB Installation
Getting Started
Finding Recipes
Using This Recipe Guide
Local Provider Recipes
IOM Provider Recipes
SAS/SHARE Provider Recipes
Base SAS Provider Recipes
OLAP Provider Recipes
Learning About SAS Connections
What You Need to Know About SAS Connections
How to Identify the SAS Providers
ADO Connection Properties for the SAS Providers
Three Ways to Open an ADO Connection Object
Using the Data Source Property to Specify All Connection-Related Properties
Connection Recipes
Opening an ADO Connection Object
Basic Connection Recipes
Connecting to Local Data
Connecting to Local Data (Single-User Server)
Connecting to a Remote SAS/SHARE Server
Connecting to a Remote SAS Workspace Server
Connecting to a Remote SAS Workspace Server Using SAS Objects
Connecting to a Remote SAS OLAP Server
Managing Connections
Supplemental Connection Recipes
Prompting Users for Connection Information by Displaying the Data Link Properties Dialog Box
Using a Microsoft Data Link (.udl) File to Provide Persistent Connection Information
Controlling Data Access Permissions with a Connection
Managing File Formats with the Local Provider
Reusing an Existing IOM Workspace
Connecting to a Specific SAS/SHARE Server Version
Data Management Recipes
Accessing Specific and Protected Data
Data Access Recipes
Identifying a Data Set and Returning Results
Specifying a Libref to Use with the IOM Provider
Opening a Password-Protected Data Set
Accessing Third-Party Data through SAS/ACCESS Engines
Displaying Metadata That Is Specific to SAS Data Sets
Reading SAS OLAP Cubes
Creating, Subsetting, and Deleting Data Sets
Creating, Subsetting, and Deleting Data Sets Recipes
Creating and Deleting Data Sets
Subsetting Data Sets for Read-Only Sequential Access
Subsetting Data Sets for Random and Update Access
Specifying How to Display Data
Displaying Data Recipes
Using SAS Formats When You Read Data
Using SAS Informats When You Write Data
Reading User-Defined SAS Formats and Informats
Padding Character Data with Blanks
Managing Missing Values
Missing Value Recipes
Reading Missing Values from a Data Set
Writing Missing Values to a Data Set
Performing Updates
Updating and Locking Recipes
Updating Recordsets
Implementing a Locking Strategy
Tips and Best Practices
Performance Tuning the SAS Providers
Properties That Affect Performance
How the "CacheSize" Property Affects Performance
How the "Maximum Open Rows" Property Affects Performance
How the SAS Page Size Property Affects Performance
Writing Code That Returns Provider Information
How to Generate a List of Supported ADO Properties
How to Retrieve Version Information for a Provider
Troubleshooting
Handling Error Objects
Using ADO to Handle Errors
Using OLE DB to Handle Errors
Known Issues
Known Issues for All Providers
Known Issues for the IOM Provider
Known Issues for the Local Provider
Appendixes
ADO: Supported Methods and Properties
ADO: Supported Cursor and Lock Type Combinations
Working with Cursor and Lock Type Combinations
Server-Side Cursor Combinations
Client-Side Cursor Combinations
OLE DB Properties: Introduction and Descriptions
OLE DB Properties: Introduction
OLE DB Properties: Descriptions
OLE DB Properties: Sorted by ADO Name, Group, and Provider
OLE DB Properties: Sorted by ADO Name
OLE DB Properties: Sorted by Data Provider
OLE DB Properties: Sorted by Group
OLE DB Interfaces
About OLE DB Interfaces
Standard OLE DB Interfaces
OLE DB for OLAP Interfaces
Custom Interfaces
Data Set Management Using the ITableDefinition Interface
Schema Rowsets
About Schema Rowsets
CATALOGS Schema Rowset
COLUMNS Schema Rowset
CUBES Schema Rowset
DIMENSIONS Schema Rowset
FUNCTIONS Schema Rowset
HIERARCHIES Schema Rowset
LEVELS Schema Rowset
MEASURES Schema Rowset
MEMBERS Schema Rowset
PROPERTIES Schema Rowset
PROVIDER_TYPES Schema Rowset
SETS Schema Rowset
TABLES Schema Rowset
OLE DB: Format Processing
About Format and Informat Processing with OLE DB
How to Specify Format Processing When Binding Columns
Using Formats for Input Operations
Overriding Formats for Input Operations
Processing Informats for Output Operations
How to Simultaneously Bind Columns to Formats and Informats
OLE DB: Column Mapping and Binding
About the Mapping and Binding Process
Returning Column Metadata
Mapping to SAS Constructs
Binding to Rowset Columns
Customized User Help for the Data Link Properties Dialog Box
Data Link Properties Dialog Box (Connection Tab)
Data Link Properties Dialog Box (Advanced Tab)
Glossary
Index here
Product
Release
SAS Providers for OLE DB
9.2
Base SAS
9.2
SAS Integration Technologies
9.2
SAS/SHARE
9.2
Type
Usage and Reference
Copyright Date
March 2008
Last Updated
15Apr2008
Previous Page
|
Next Page
Basic Connection Recipes
This chapter provides sample code that you can use to open an ADO Connection object for access to local and remote data. Here is a list of the recipes in this chapter:
Connecting to Local Data
Connecting to Local Data (Single-User Server)
Connecting to a Remote SAS/SHARE Server
Connecting to a Remote SAS Workspace Server
Connecting to a Remote SAS Workspace Server Using SAS Objects
Connecting to a Remote SAS OLAP Server
See Also
Supplemental Connection Recipes
Data Access Recipes
Previous Page
|
Next Page
|
Top of Page
