Limitations compared to ANSI SQL-92

Actuate SQL has the following limitations compared to ANSI SQL-92:

Only the SELECT statement is supported.

Data types are limited to integers, strings, timestamps, floating point numbers, and decimals.

Intersection and set difference operations are not available.

UNION and UNION DISTINCT are not supported. UNION ALL is supported. To obtain the same results as a UNION DISTINCT operation, perform a UNION ALL operation followed by a SELECT DISTINCT operation. For example, IO3 performs a UNION ALL operation on IO1 and IO2:

SELECT empNo, eName

FROM "IO1.iob" AS IO1

UNION ALL

SELECT empNo, eName

FROM "IO2.iob" AS IO2

To obtain distinct results from IO3, create IO4, which performs a SELECT DISTINCT operation on IO3:

SELECT DISTINCT empNo, eName

FROM "IO3.iob" AS IO3

LIKE operator patterns and escape characters must be literal strings, parameters, or expressions. The LIKE operator does not support column references, subqueries, or aggregate functions, for example, MAX and AVG.

Unnamed parameters are not supported.

Some subqueries are not supported.

Not all ANSI SQL-92 functions and operators are available.

Copyright Actuate Corporation 2012