If a query you execute specifies totals, you can specify output variations on the TOTALING OPTIONS panel (DQE30) during execution. Totaling options are also available by PF key or command during online output display. (See Changing the Format of DQL Mode Total Output).
The available totaling variations are:
To see examples of these totaling variations, see DQL Mode Totaling Options Examples.
The query specifies which numeric columns are totaled in the PRINT statement of the query. A SORT statement can specify control breaks with parentheses around column names. If totals are specified, they occur at control breaks and at the end of the report. A query can produce other kinds of calculation results, like sums, counts, averages, maximums, and minimums of report columns. These results are produced by WHEN/DO statements in the query.
You can suppress the output totals or the detail, or select only one control break for totals if the query specifies more than one control break column.
|
Copyright © 2014 CA.
All rights reserved.
|
|