The Actuate SQL keywords are shown in the following list:
ALL
AND
ANY
AS
ASC
AVG
BETWEEN
BY
CARDINALITY
CASE
CAST
COUNT
DEC
DECIMAL
DEPENDENT
DESC
DISTINCT
DOUBLE
ELSE
END
ESCAPE
EXEC
EXISTS
FALSE
FILTERS
FROM
GROUP
HAVING
IN
INNER
INT
INTEGER
IS
JOIN
LEFT
LIKE
MAX
MERGE
MIN
NL
NOT
NULL
ON
OPTION
OPTIONAL
OR
ORDER
OUTER
PRAGMA
PRECISION
RIGHT
SELECT
SINGLE
SUM
THEN
TIMESTAMP
TRUE
UNION
VARCHAR
WHEN
WHERE
WITH
Actuate SQL keywords are not case-sensitive. To prevent incompatibility with other versions of SQL, do not use SQL-92 keywords. If you use an identifier that is also a keyword, place double quotes around the identifier.
ALL