Preface

This manual details ODBC conformance and SQL language support provided by the Dharma DataLink SDK. It also describes configuration of the ODBC SDK Drivers.

Audience

This manual is intended for a variety of audiences that use Dharma DataLink SDK drivers to access data in proprietary storage systems:

• Administrators who set up access to a proprietary storage system from existing ODBC applications
• Application programmers writing ODBC applications that will access proprietary data through the ODBC Driver

Structure

The manual contains the following chapters and appendixes:

Chapter 1

Introduces the ODBC SDK and its components.

Chapter 2

Describes configuring data sources to use ODBC SDK drivers.

Chapter 3

Details the ODBC Driver's support for the ODBC standard, including information it returns to the SQLGetInfo call, and which ODBC API calls it supports.

Chapter 4

Describes language elements common to many SQL statements.

Chapter 5

Provides detailed reference material on each SQL statement, in alphabetic order.

Appendix A

Provides reference material on utilities used in ODBC Server administration.

Appendix B

Lists reserved words.

Appendix C

Lists error messages.

Appendix D

Summarizes the tables in the data dictionary.

Appendix E

Lists the maximum sizes for various attributes of the ODBC Server environment.

Conventions

Syntax diagrams appear in helvetica type and use the following conventions:

UPPERCASE

Uppercase type denotes reserved words. You must include reserved words in statements, but they can be upper or lower case.

lowercase

Lowercase type denotes either user-supplied elements or names of other syntax diagrams. User-supplied elements include names of tables, host-language variables, expressions, and literals. Syntax diagrams can refer to each other by name. If a diagram is named, the name appears in lowercase type above and to the left of the diagram, followed by a double-colon (for example, privilege ::). The name of that diagram appears in lowercase in diagrams that refer to it.

{ }

Braces denote a choice among mandatory elements. They enclose a set of options, separated by vertical bars ( | ). You must choose at least one of the options.

[ ]

Brackets denote an optional element or a choice among optional elements.

|

Vertical bars separate a set of options.

...

A horizontal ellipsis denotes that the preceding element can optionally be repeated any number of times.

( ) , ;

Parentheses and other punctuation marks are required elements. Enter them as shown in syntax diagrams.

For More information

Microsoft ODBC Programmer’s Reference, Version 3.0

Describes the ODBC interface, its features, and how applications use it.