TOCPREVNEXTINDEX

AcuODBC User's Guide
Version 6.0

A.1.1 SQL Conformance

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

F = Fully supported
P = Partially supported
E = Produces error
I = Ignored

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


Acucorp, Inc.
Voice: (800) 262-6585 (U.S.A. and Canada)
Voice: (858) 689-4500
Fax: (858) 689-4550

Please share your comments on this manual
or on any Acucorp documentation with the
Acucorp Communications Department.
TOCPREVNEXTINDEX
1988-2003 Acucorp, Inc.
All rights reserved.