8 Reserved Words

TimesTen reserves words for use in SQL statements.

To use one of these words as an identifier (such as a table name or column name), enclose the reserved word in quotes. Otherwise, syntax errors may occur.

Reserved words
AGING
ALL
ANY
AS
BETWEEN
BINARY_DOUBLE_INFINITY
BINARY_DOUBLE_NAN
BINARY_FLOAT_INFINITY
BINARY_FLOAT_NAN
CASE
CHAR
COLUMN
CONNECTION
CONSTRAINT
CROSS
CURRENT_SCHEMA
CURRENT_USER
CURSOR
DATASTORE_OWNER
DATE
DECIMAL
DEFAULT
DESTROY
DISTINCT
FIRST
FLOAT
FOR
FOREIGN
FROM
GROUP
HAVING
INNER
INTEGER
INTERSECT
INTERVAL
INTO
IS
JOIN
LEFT
LIKE
LONG
MINUS
NULL
ON
ORA_SYSDATE
ORDER
PRIMARY
PROPAGATE
PUBLIC
READONLY
RIGHT
ROWNUM
ROWS
SELECT
SELF
SESSION_USER
SET
SMALLINT
SOME
SYSDATE
SYSTEM_USER
TO
TT_SYSDATE
UID
UNION
UNIQUE
UPDATE
USER
USING
VARCHAR
WHEN
WHERE
WITH