Core Functions
Initializing a
Data Source Component
Opening an
Existing Data Set
Data Set Management
via ITableDefinition
Column Mapping
and Binding
Bookmarks
and Random Access
Schema Rowsets
Command Processing
Format Processing
Appendices
Installation Notes
Implemented Interfaces
Performance Considerations
OLE DB Customizations
Properties
Properties by Provider
Properties by Group
Alphabetical List
Error Objects
Using VBScript
Programming With C++
|
|
|
|
|
Using the IOM Data Provider
The SAS(R) IOM Data Provider is an OLE DB data provider that delivers
access to SAS data sets found in SAS Integrated Object Model (IOM)
servers.
An OLE DB data provider is a set of software components that expose a data source to applications in conformance with Microsoft's OLE DB specification. This specification, built on the COM model, provides applications with standard interfaces to use when accessing data from any type of information source. OLE DB providers may expose many COM interfaces. These interfaces are grouped into seven object types: DataSource, Session, Command, Rowset, Index, ErrorObject and Transaction. The IOM provider currently supports all but the Index and Transaction objects.
OLE DB providers, including the IOM provider, may be used by applications written in Visual C++, VBScript, Java, JScript or Visual Basic. Applications may be written to the higher level ActiveX Data Objects (ADO) interface using any of these languages, or directly to the OLE DB specification using Visual C++. This document pertains primarily to Visual C++ applications.
This document also assumes a working knowledge of the OLE DB architecture and specification. For more information about OLE DB, see the following information sources:
- Microsoft Corporation. (1998), OLE DB
Programmer's Reference and Data Access SDK. Redmond Washington: Microsoft Press
- Sussman, David. (1999) ADO 2.1 Programmer's Reference , Chicago Wrox Press Inc.
- Wood, Chuck. OLE DB and ODBC Developer's Guide (1999) Foster City, CA: IDG Books Worldwide
Feature set
Through the OLE DB interfaces, the IOM provider adds to consumer programs a range of functionality which includes:
- Both read-only and update access to SAS data files on all
platforms that IOM supports
- Either exclusive access (member level lock) or
multiple user access (record level lock) to SAS data files, selectable on a
per- rowset open basis
- Both immediate and delayed update modes through the
IRowsetChange and IRowsetUpdate interfaces
- Creation of new data sets through the ITableDefinition
interface
- Random access services via the IRowsetLocate
interface
- SQL query and command support through the OLE DB
Command object
- Basic OLE DB schema rowsets, which enable clients to
discover metadata about the data source they are connected to
- Integrated SAS formatting services. The core set of SAS formats that have been included can be used when reading or modifying data.
To get started quickly with the SAS IOM Data Provider, you can refer to the
SAS® 9 Data Providers: ADO/OLE DB Cookbook.
This cookbook, which applies to all three SAS OLE DB data providers, contains ADO examples written in Microsoft Visual Basic as well as OLE DB examples written in Microsoft Visual C++. You can either apply the examples directly or use them with minimal modification.
|