Previous Topic: JDBC ConformanceNext Topic: Database Type Mapping between JDBC and CA IDMS

JDBC Programmer Reference › JDBC Conformance › SQL Conformance

SQL Conformance

To be JDBC compliant, a JDBC driver must support ANSI SQL-92 Entry Level. This is consistent with ODBC 3.0. With a few minor exceptions, CA IDMS conforms to the ANSI SQL-92 entry level standard. Both the ODBC and JDBC drivers pass most SQL statements to the CV essentially unchanged, other than converting escape sequences into CA IDMS equivalents.

Note: For more information about SQL conformance, see the chapter "ODBC Programmer Reference."