Summary terms

The basic concept in a summary is the summary level. A summary level is a combination of one or more fields used as summary key; every key value is kept once per summary level, and is crossed with the summary levels above and below. In the preceding summary examples, first (CLASS OWNER) and QUAL were used as keys; later CLASS, OWNER, and QUAL were used. The (CLASS OWNER) combination is called a compound key.

In the SUMMARY command, summary levels are separated by an asterisk (*). Each summary level must contain at least one key variable. A field is always a valid key variable, unless it has been converted to a statistics variable by using one of the key modifiers listed in Table 1. Other valid key variables are define variables of the types in Table 1. DEFINE variables of the type listed in Table 1 are statistics variables. Statistics variables can be included in the SUMMARY command, but they are not valid key variables.

In an ISPF display, each summary level has its own display panel; in a batch report, each summary level has its own output line. The examples at the end of this section show output from sample summary reports; for an example ISPF summary, see menu option AU.S Status audit.

The following example shows a simple SUMMARY command, summarizing CLASS by OWNER by QUAL. This example does not include user-defined statistic variables; as described in the following text, a 'Count' statistic is added automatically to each level.

   newlist type=racf
    summary class * owner * qual

The following example shows a summary command with one summary level and two statistics: a count and a relative frequency. The example lists all type codes in the ACF2 infostorage database, the number of rule sets encountered per type code, and the relative frequency of each type code:

NewList Type=ACF2_InfoRule
   Define Cnt count
   Define Frq freq
   Summary  Type Cnt Frq