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 Pervasive Relational Interface fully supports the minimum SQL grammar, as well as many core and extended grammar statements. The Pervasive Relational Interface support for SQL grammar is summarized in the following table.

Table 2-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 (positional)
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
- timestamp-literal
Subqueries
UNION
SET SECURITY
UPDATE (positional)
UPDATE (searched)

Delimited Identifiers in SQL Statements

Column names and table names can occur as delimited identifiers if they contain non-ODBC 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-ODBC standard character.

SELECT "password" FROM my_pword_tbl

"Password" is a keyword in the SET PASSWORD statement.