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
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 character | Reserved words |
---|---|
A | ALL, AND, ANY, AS, ASC, AST, AVG |
B | BETWEEN, BIGINT, BINARY, BOOLEAN, BY |
C | CASE, CHAR, CHARACTER, CON, COUNT |
D | DATE, DAY, DEC, DECIMAL, DEFAULT, DELETABLE, DELETE, DESC, DISTINCT, DOUBLE, DSTREAM |
E | ELSE, END, EOF, EQ, EXISTS |
F | FALSE, FLOAT, FROM |
G | GE, GT, GROUP |
H | HAVING, HOUR |
I | IDSTREAM, IN, INSERT, INSTANT, INT, INTEGER, IS, ISTREAM |
J | No reserved words |
K | No reserved words |
L | LATEST, LE, LIKE, LIMIT, LLP, LP, LRP, LT |
M | MAX, MILLISECOND, MIN, MINUTE, MIS |
N | NE, NOT, NOW, NULL, NUMERIC |
O | OR, ORDER, OTHER |
P | P_INT, PARTITION, PLS, POM, PR, PREV |
Q | No reserved words. |
R | RANGE, RANKING, REAL, RECENT, RELATIONAL, ROWS, RSTREAM |
S | SECOND, SELECT, SMALLINT, SOME, SQU, SUB, SUM |
T | THEN, TINYINT, TIME, TIMESTAMP, TRUE |
U | UNBOUNDED, UNION, UNKNOWN, UPDATE |
V | VARBINARY, VARCHAR |
W | WHEN, WHERE, WITH, WQU |
X | No reserved words |
Y | No reserved words |
Z | No reserved words |