Indicates changes of values with line breaks.
BREAK.SUP field ["'code'"]
clause inserts a blank line break indicator in the display at each point where the field
value changes. Optionally, you can specify a code
to provide the current field
value to the header, or a code
to issue a page break at each point where the field
value changes. "'N'"
is a synonym for "'P'"
You can specify multiple BREAK.SUP
clauses to insert breaks for multiple levels of sorting.
If the DET.SUP keyword is specified, CMQL detects breaks where the break field
, but only outputs a break line for it if it is the lowest level break. If both the DBL.SPC and DET.SUP keywords are specified, the DBL.SPC overrides the DET.SUP break line suppression.
indicates a field
value change with a blank line. BREAK.ON
indicates a field
value change either with *** (the default) or a user-specified break string.
Multiple CMQL clauses may be specified in any order. The order of application of CMQL clauses is always the same. The BREAK.SUP
clause is applied after the WITH
clause, the SAMPLED
clause (if present), and the SAMPLE
clause (if present).
The following example displays the a break indicator each time the F1 field value changes:
LIST VOC BREAK.SUP F1 WHERE FILENAME >= "A"
It lists output such as the following, where blank line breaks indicate changes in the F1 value:
If you wish to display the actual field
values, you must specify the field, as shown in the following:
LIST VOC F1 BREAK.SUP F1 WHERE FILENAME >= "A"
The following example shows the use of the code
parameter to supply the current F1 value to each page header and issue a page break:
LIST VOC BY F1 BREAK.SUP F1 "'BP'" HEADING "Type='B'"
In this case, the VOC is sorted by F1 values. Each time the F1 field value changes, the 'P'
letter code issues a page break. The 'B'
letter code supplies the current F1 field value to the page header. Note that the F1 values are not displayed; however, the F1 value for the current page is shown in the page header.
© 1997-2019 InterSystems Corporation, Cambridge, MA