EQL reserved keywords

EQL reserves certain keywords for its exclusive use.

Reserved keywords

Reserved keywords cannot be used in EQL statements as identifiers, unless they are delimited by double quotation marks. For example, this EQL snippet uses the YEAR and MONTH reserved keywords as delimited identifiers:

DEFINE Input AS SELECT
   DimDate_CalendarYear AS "Year",
   DimDate_MonthNumberOfYear AS "Month",
   ...

However, as a rule of thumb it is recommended that you do not name any identifier with a name that is the same as a reserved word.

The reserved keywords are:

AND, AS, ASC, BETWEEN, BY, CASE, COUNT, CROSS, CUBE, CURRENT, CURRENT_DATE,
CURRENT_TIMESTAMP, DATE, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_YEAR, DEFINE, DESC, ELSE, 
EMPTY, END, EVERY, FALSE, FOLLOWING, FOREACH, FROM, FULL, GROUP, GROUPING, HAVING,
HOUR, IN, INNER, IS, JOIN, JULIAN_DAY_NUMBER, LEFT, LET, MEMBERS, MINUTE, MONTH, NOT, 
NULL, ON, OR, ORDER, OVER, PAGE, PARTITION, PERCENT, PRECEDING, QUARTER, RANGE, RETURN, 
RIGHT, ROLLUP, SATISFIES, SECOND, SELECT, SETS, SOME, SYSDATE, SYSTIMESTAMP, THEN, 
TRUE, UNBOUNDED, UNPAGED, VALUE, WEEK, WHEN, WHERE, WITH, YEAR

Keep in mind that many function names (such as SUM and STRING_JOIN) are not keywords and, therefore, could be used as identifiers. However, as a best practice, you should also avoid using function names as identifiers.

Reserved punctuation symbols

, (comma)
; (semicolon)
. (dot)
/ (division)
+ (plus)
- (minus)
* (star)
< (less than)
> (greater than)
<= (less than or equal)
=> (greater than or equal)
= (equal)
<> (not equal)
( (left parenthesis)
) (right parenthesis)
{ (left brace)
} (right brace)
[ (left bracket)
] (right bracket)