B.2 SQL Conformance

SQL Conformance Level	Category	Element	AcuODBC V 4.3
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	E[3]
		LONG VARCHAR	E[6]
Core SQL Grammar	Language	ALTER TABLE	E[1]
		CREATE INDEX	E[1]
		DROP INDEX	E[1]
		CREATE VIEW	E[1]
		DROP VIEW	E[1]
		GRANT	E[1]
		REVOKE	E[1]
		full SELECT	F
	Expressions	subquery	E[2]
		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	E[2]
		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] Only TOUPPER and TOLOWER functions are supported.

[5] Only left and right outer joins are supported.

[6] Only pic x items of 255 characters or less are supported.