SQL Grammar Support
The ODBC v2.5 specification provides three levels of SQL grammar support: Minimum, Core, and Extended. Each higher level provides more fully-implemented data definition and data manipulation language support.
The Relational Interface fully supports the minimum SQL grammar, as well as many core and extended grammar statements. The Relational Interface support for SQL grammar is summarized in the following table. The grammar statements are documented in SQL Engine Reference.
Table 7
SQL Grammar Support 
SQL Grammar Statement
Minimum
Core
Extended
ALTER TABLE
 
 
* 
CREATE GROUP
 
 
* 
CREATE INDEX
 
* 
 
CREATE PROCEDURE
 
 
* 
CREATE TABLE
 
 
* 
CREATE TRIGGER
 
 
* 
CREATE VIEW
 
* 
 
DELETE (positioned)
* 
 
 
DELETE (searched)
* 
 
 
DROP GROUP
 
 
* 
DROP INDEX
 
* 
 
DROP PROCEDURE
 
 
* 
DROP TABLE
* 
 
 
DROP TRIGGER
 
 
* 
DROP VIEW
 
* 
 
GRANT
 
* 
 
INSERT
* 
 
 
JOIN LEFT OUTER (Select)
 
 
* 
REVOKE
 
* 
 
SELECT (with INTO)
* 
 
 
Approximate Numeric Literal
 
* 
 
Between Predicate
 
* 
 
Correlation Name
 
* 
 
Date Arithmetic
 
 
* 
Date Literal
 
 
* 
Exact Numeric Literal
 
* 
 
extended predicates
 
 
* 
In Predicate
 
* 
 
Set Function
 
* 
 
Time Literal
 
 
* 
Time Stamp Literal
 
 
* 
Subqueries
 
* 
 
SET SECURITY
 
 
* 
UPDATE (positioned)
* 
 
 
UPDATE (searched)
* 
 
 
UNION
 
 
* 
Delimited Identifiers in SQL Statements
Column names and table names can occur as delimited identifiers if they contain non-standard characters. If an identifier is a keyword, it must delimited.
The delimiter character for identifiers is the double-quote.
Examples
SELECT "last-name" FROM "non-standard-tbl"
The hyphen is a non-standard character.
SELECT "password" FROM my_pword_tbl
“Password” is a keyword in the SET PASSWORD statement.