Caché MultiValue Query Language (CMQL) Reference
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.
The following are CMQL clause keywords:
The following are CMQL subclause keywords:
Used with the EVAL
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.
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.