A.2 SQL Conformance

SQL Conformance Level
Category
Element
AcuODBC
V 5.0
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
F[6]

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[7]

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
E[2]

positioned DELETE
E[2]

SELECT FOR UPDATE
F

UNIONS
E[2]

Expressions
scalar functions (like SUBSTRING and ABS)
P[4]

date
E[3]

time
E[3]

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
E[3]

TIME
E[3]

TIMESTAMP
F

Batch SQL statements
E[2]

Procedure calls
E[2]

F = Fully supported P = Partially supported E = produces Error I = Ignored [1] AcuODBC doesn't implement DDL statements. [2] There are no requests for this functionality; 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] The view is temporary for the connection (if created dynamically)

[7] Only EXISTS subquery is supported.

SQL Conformance Level	Category	Element	AcuODBC V 5.0
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	F[6]
		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[7]
		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	E[2]
		positioned DELETE	E[2]
		SELECT FOR UPDATE	F
		UNIONS	E[2]
	Expressions	scalar functions (like SUBSTRING and ABS)	P[4]
		date	E[3]
		time	E[3]
		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	E[3]
		TIME	E[3]
		TIMESTAMP	F
		Batch SQL statements	E[2]
		Procedure calls	E[2]