SQL Conformance Level

The Desktop Database Drivers conform to the Minimum SQL Grammar level (as defined in ODBC 2.x), with the following Core and Extended enhancements. For more information about the SQL support provided by the Desktop Database Drivers, see the SQL Support section later in this chapter.

• Approximate numeric literals (Core)
  
  
• ALTER TABLE statement (Core)
  
  
• Binary literals (Extended)
  
  
• Between…And operator (BETWEEN predicate) (Core)
  
  
• Correlation names (Core)
  
  
• EXISTS predicate (Core)
  
  
• IN (valuelist) (Core)
  
  
• Procedure Invocation (Extended)
  
  
• SELECT statement including GROUP BY, HAVING, and UNION clauses (Extended)
  
  
• Subqueries (sub-SELECTs) (Core)