uCosminexus Stream Data Platform - Application Framework Application Development Guide
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 |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.