SQL language conformance

Supported and unsupported SQL grammar is listed in this topic.

SQL grammar supported

The SQL grammar below is supported on D3 7.5.

Minimal SQL grammar supported

All ODBC minimum SQL grammar is supported, including:

Create Table, Drop Table
Select, Insert, Update Searched and Delete Searched
Simple Expressions
Data types: CHAR, VARCHAR

Core SQL grammar supported

This ODBC core SQL grammar is supported:

Alter Table, Create Index, Drop Index
Full SELECT

The retrieval capabilities present are:

simple queries
multi-table queries (equi-joins, non-equi-joins, self-joins)
summary queries
grouped queries (GROUP BY clause)
group search conditions (HAVING clause)
subqueries
subquery search conditions
nested subqueries
correlated subqueries
Functions: SUM, MAX, MIN, COUNT, AVG
Data types: DECIMAL, NUMERIC, SMALLINT, INTEGER, REAL, FLOAT, DOUBLE PRECISION

Core SQL grammar not supported

This ODBC core SQL grammar is not supported:

Create/Drop View, Grant/Revoke

Extended SQL grammar supported

This ODBC extended SQL grammar is supported:

Positioned Update, Positioned Delete, Select for Update
Unions
Most scalar functions such as SUBSTRING and ABS, date literals
Datatypes: DATE

Extended SQL grammar not supported

This ODBC extended SQL grammar is not supported:

Bit, TinyInt, BigInt, Binary, VarBinary, Long VarBinary data types
Batch SQL
SQL procedure calls
Outer joins