CMQL Keywords
Non-Functional CMQL Keywords
The following CMQL keywords may be included in a query for readability, but are ignored by CMQL and perform no function:
A, AN, ANY, ARE, FILE, FOR, IN, INVISIBLE, ITEMS, OF, PRINT, THAN, THE.
The Attribute 2 value for these keywords is TA.
CMQL Clause Keywords
The following are CMQL clause keywords:
AVERAGE, AVG, BETWEEN, BREAK.ON, BREAK-ON, BREAK.SUP, BY, BY-DSND, BY-EXP, BY-EXP-DSND, BY.DSND, BY.EXP, BY.EXP.DSND, CALC, COL.HDG, COL.SPACES, COL.SPCS, CONV, CONVERSION, DISPLAY.LIKE, DISPLAYLIKE, DISPLAY.NAME, ENUM, EVAL, FIRST, FMT, FOOTER, FOOTING, FROM, HEADER, HEADING, IF, LPTR, MAX, MIN, PCT, PERCENT, PREFETCH, REQUIRE.SELECT, SAMPLE, SAMPLED, SAMPLING, SAVING, SELECT.ONLY, TOTAL, WHEN, WHERE, WITH.
CMQL Subclause Keywords
The following are CMQL subclause keywords:
-
Used with the EVAL clause: AS.
-
Used with the SAVING clause: NO.NULLS, UNIQUE.
-
Used in the TOTAL clause (and other numeric calculation clauses): GRAND-TOTAL, GRAND.TOTAL.
-
Used in the WHEN clause: ASD, ASSOCIATED.
-
Used in the WITH clause (and its synonyms) and described in the WITH clause:
Equality operators: #, AFTER, BEFORE, EQ, EQUAL, GE, GREATER, GT, LE, LESS, LT, NE, NOT.
Other keywords: AND, EACH, EVERY, ID.ONLY, IS.NULL, IS.NOT.NULL, LIKE, MATCHES, MATCHING, NO, NOT.MATCHING, ONLY, OR, SAID, SPOKEN, UNLIKE, WITHOUT.
MultiValue Verb Keywords
The following are MultiValue command keywords: ALL, DATA, DICT, DIR, OFF, ON, TEMPL, TO, USING.
The following are display formatting keywords. They are described with the CMQL commands that support them:
COL-HDR-SUPP, COL.HDR.SUPP, COL.SUP, COL-SUPP, COUNT.SUP, DBL.SPC, DBL-SPC, DET.SUP, DET-SUPP, HDR.SUP, HDR-SUPP, ID-SUP, ID.SUP, ID-SUPP, NI.SUP, NI-SUPP, NO.PAGE, NOPAGE, SUPP, VERT, VERTICALLY.