| SQL Conformance Level | Category | Element | AcuODBC V 5.2 |
| Minimum SQL Grammar | Language | CREATE TABLE | E[1] |
|
| DROP TABLE | E[1] |
|
|
| simple SELECT (includes simple joins and self-joins) | F |
|
| | simple INSERT | F |
|
|
| simple UPDATE | F |
|
|
| simple DELETE | F |
|
| Expressions | All minimum SQL expressions | F |
|
| Data types | CHAR | F |
|
|
| VARCHAR | F |
|
|
| LONG VARCHAR | F |
| Core SQL Grammar | Language | ALTER TABLE | E[1] |
|
|
| CREATE INDEX | E[1] |
|
|
| DROP INDEX | E[1] |
|
|
| CREATE VIEW | E |
|
|
| DROP VIEW | E[1] |
|
|
| GRANT | E[1] |
|
|
| REVOKE | E[1] |
|
|
| full SELECT | F |
|
|
| full INSERT
(Insert SELECT into table values, etc.) | F |
|
| Expressions | subquery | P |
|
|
| set functions (like SUM and MIN) | F |
|
| Data types | DECIMAL | F |
|
|
| NUMERIC | F |
|
|
| SMALLINT | F |
|
|
| INTEGER | F |
|
|
| REAL | F |
|
|
| FLOAT | F |
|
|
| DOUBLE PRECISION | F |
| Extended SQL Grammar | Language | outer joins | P[5] |
|
|
| positioned UPDATE | F |
|
|
| positioned DELETE | F |
|
|
| SELECT FOR UPDATE | F |
|
|
| UNIONS | E[2] |
|
| Expressions | scalar functions (like SUBSTRING and ABS) | P[4] |
|
|
| date | F |
|
|
| time | F |
|
|
| timestamp literals | F |
|
| Data types | BIT | E[3] |
|
|
| TINYINT | E[3] |
|
|
| BIGINT | E[3] |
|
|
| BINARY | E[3] |
|
|
| VARBINARY | E[3] |
|
|
| LONG VARBINARY | E[3] |
|
|
| DATE | F |
|
|
| CHAR | F |
|
|
| VARCHAR | F |
|
|
| TIME | F |
|
|
| TIMESTAMP | F |
|
|
| Batch SQL statements | E[2] |
|
|
| Procedure calls | E[2] |
[1] AcuODBC doesn't implement DDL statements.
[2} This functionality is not supported.
These statements output a "syntax error" message.
[3] AcuODBC implements COBOL data types only.
[4] The following functions are supported:
String:
ASCII CHAR CONCAT LCASE LENGTH LOCATE LTRIM RTRIM SUBSTRING UCASE
Numeric:
ABS ACOS ASIN ATAN CEILING COS COT EXP FLOOR LOG LOG10 ROUND SIGN SQRT TAN TRUNCATE
[5] Only left outer joins are supported.
[6] Only EXISTS subquery is supported.