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.