8 Reserved Words

TimesTen reserves words for use in SQL statements. You cannot use reserved words as non-quoted identifiers. To use one of these words as an identifier, enclose the reserved word in double quotes.

In this example, since ALL is a reserved word, the CREATE TABLE operation fails.

Command> CREATE TABLE all (id NUMBER);
 7025: Invalid use of reserved keyword "ALL", character position: 14
CREATE TABLE all (id NUMBER)
             ^^^
The command failed.

By enclosing the reserved word ALL in double quotes, the CREATE TABLE operation succeeds.

Command> CREATE TABLE "ALL" (id NUMBER);

Here is the list of reserved words:

• AGING

• ALL

• ANY

• AS

• BETWEEN

• BINARY_DOUBLE_INFINITY

• BINARY_DOUBLE_NAN

• BINARY_FLOAT_INFINITY

• BINARY_FLOAT_NAN

• CASE

• CHAR

• COLUMN

• COLUMNAR

• CONSTRAINT

• CROSS

• CURRENT_SCHEMA

• CURRENT_USER

• DATASTORE_OWNER

• DATE

• DECIMAL

• DEFAULT

• DISTINCT

• DISTRIBUTE

• 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