Additional Supported ODBC SQL Grammar

The ODBC drivers completely support the Minimum ODBC 2.5 grammar and the following clauses in the Core and Extended ODBC 2.5 grammar. Additional information can be displayed by jumping to the ALTER TABLE Statement, Correlation Names, and Procedure Invocation topics.

• Approximate numeric literal (Core)

• ALTER TABLE Statement (Core)

• Binary literals (Extended)

• Correlation Names (Core)

• Procedure Invocation (Extended)

• BETWEEN Predicate (Core)

• CREATE INDEX Statement

• Date Arithmetic

• Jet: Date, Time, and Timestamp Literals

• DROP INDEX Statement

• Fixed-Width Text File

• GROUP BY expression-list

• ORDER BY expression-list

• ORDER BY with GROUP BY

• EXISTS predicate (Core)

• IN (valuelist) (Core)

• Jet: Outer Joins (Extended)

• SELECT statement (Extended) (including GROUP BY, HAVING, and UNION clauses)

• Subqueries (SUBSELECTs) (Core)

• Scalar Functions

• Table Names