ODBC Conformance Levels

Level

Conformance

API

Supports Level 1 and some Level 2 API Functions.

Grammar

Supports minimum SQL grammar and most of ODBC Core Grammar.

Supports subqueries that use nested SELECT statements. See Structured Query Language (SQL) and the BASIS ODBC Driver for more information.

Character Translation

Supported, see Character Translation for details.

Isolation

Supports isolation level zero. Updates, inserts, and deletes occur instantaneously.

Supported Connections

Supports multiple connections to multiple BASIS Data Sources. The number of open data sources and statement connections allowed is limited only by available memory.