CMQL Keywords

A list of keywords used in CMQL clauses.

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.