Caché MultiValue Query Language (CMQL) Reference
CMQL Keywords
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

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:
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.