ODBC conformance

SAP Sybase IQ provides support for ODBC 3.5, which is supplied as part of the Microsoft Data Access Kit 2.7.

Levels of ODBC support

ODBC features are arranged according to level of conformance. Features are either Core, Level 1, or Level 2, with Level 2 being the most complete level of ODBC support. These features are listed in the Microsoft ODBC Programmer's Reference at http://msdn.microsoft.com/en-us/library/ms714177.aspx.

Features supported by SAP Sybase IQ

SAP Sybase IQ supports the ODBC 3.5 specification as follows:

Core conformance – SAP Sybase IQ supports all Core level features.
Level 1 conformance – SAP Sybase IQ supports all Level 1 features, except for asynchronous execution of ODBC functions.
SAP Sybase IQ supports multiple threads sharing a single connection. The requests from the different threads are serialized by SAP Sybase IQ.
Level 2 conformance – SAP Sybase IQ supports all Level 2 features, except for the following ones:
- Three part names of tables and views. This is not applicable for SAP Sybase IQ.
- Asynchronous execution of ODBC functions for specified individual statements.
- Ability to time out login requests and SQL queries.