3.2.1 Specifying keywords

A word, such as the name of a CQL statement (for example, SELECT or UNION) that must be specified in order to use a function is called a keyword.

For details about the meanings of keywords, see 4. CQL Reference.

The following figure shows examples of specifying keywords.

Figure 3-1 Keyword specification examples

[Figure]

Since most keywords are defined as system reserved words, they must be specified in their predetermined positions.

A CQL keyword that is not defined as a reserved word, however, can also be used as a name. In this case, the names are not case-sensitive.

The following table shows the character strings defined as system reserved words, in alphabetic order grouped by their leading character.

Table 3-3 Character strings defined as system reserved words

Leading characterReserved words
AALL, AND, ANY, AS, ASC, AST, AVG
BBETWEEN, BIGINT, BINARY, BOOLEAN, BY
CCASE, CHAR, CHARACTER, CON, COUNT
DDATE, DAY, DEC, DECIMAL, DEFAULT, DELETABLE, DELETE, DESC, DISTINCT, DOUBLE, DSTREAM
EELSE, END, EOF, EQ, EXISTS
FFALSE, FLOAT, FROM
GGE, GT, GROUP
HHAVING, HOUR
IIDSTREAM, IN, INSERT, INSTANT, INT, INTEGER, IS, ISTREAM
JNo reserved words
KNo reserved words
LLATEST, LE, LIKE, LIMIT, LLP, LP, LRP, LT
MMAX, MILLISECOND, MIN, MINUTE, MIS
NNE, NOT, NOW, NULL, NUMERIC
OOR, ORDER, OTHER
PP_INT, PARTITION, PLS, POM, PR, PREV
QNo reserved words.
RRANGE, RANKING, REAL, RECENT, RELATIONAL, ROWS, RSTREAM
SSECOND, SELECT, SMALLINT, SOME, SQU, SUB, SUM
TTHEN, TINYINT, TIME, TIMESTAMP, TRUE
UUNBOUNDED, UNION, UNKNOWN, UPDATE
VVARBINARY, VARCHAR
WWHEN, WHERE, WITH, WQU
XNo reserved words
YNo reserved words
ZNo reserved words