Specifying summary expressions
The attributes of a summary record are set according to a summary option that is appropriate for the attribute's data type. For each resource table attribute, CICSPlex SM defines a default summary option. CICSPlex SM uses these defaults when summarizing records unless you explicitly override them.
You tell CICSPlex SM how to summarize the attributes in a record by specifying a summary expression on the SUMOPT option of the GROUP command. A summary expression is a character string that consists of one or more summary options and the resource table attributes to which they apply.
where:Summary Expression .------------------------. | .-,----. | V V | | >>---sumopt--(----attr-+--)-+--.-------------------------------><
- sumopt
- Is the summary option to be used for the specified resource table
attributes:
- AVG
- Provides the average attribute value. Valid for numeric fields only.
- DIF
- Provides those characters that are common to all underlying records and displays an asterisk (*) for those not common. Valid for character fields only.
- LIKE
- Provides the CVDA or EYUDA value, if all records contain a common value. Otherwise, displays N/A. Valid for CVDA and EYUDA fields only.
- MAX
- Provides the maximum attribute value.
- MIN
- Provides the minimum attribute value.
- SUM
- Provides the sum of the attribute values. Valid for numeric fields only.
- attr
- Is the name of an attribute in the resource table. Note: You can summarize only on those attributes that have a length of 251 or less.You can specify as many attribute names for each summary option as you like.
SUM(USECOUNT) MAX(PRIORITY,TWASIZE).
By default, the values for these attributes would be averaged. But this summary expression specifies that each summary record should include the sum of all USECOUNT values and the maximum PRIORITY and TWASIZE values.
Table 1 shows the valid summary options for the various datatypes.
| Valid summary options by attribute data type | ||||||
|---|---|---|---|---|---|---|
| AVG | DIF | LIKE | MAX | MIN | SUM | |
| ADDRESS | X | X | ||||
| AVG | X | X | X | X | ||
| AVG3 | X | X | X | X | ||
| BIN | X | X | X | X | ||
| BIT | X | X | ||||
| CHAR | X | X | X | |||
| CODEBIN | X | X | X | X | ||
| COMPID | X | X | ||||
| CVDAS | X | X | X | |||
| CVDAT | X | X | X | |||
| DATE | X | X | ||||
| DATETIME | X | X | ||||
| DEC | X | X | ||||
| DECSTP | X | X | ||||
| EYUDA | X | X | X | |||
| HCHAR | X | X | X | |||
| HEX | X | X | X | |||
| HHMM | X | X | ||||
| INTVMSEC | X | X | X | X | ||
| INTVSEC | X | X | X | X | ||
| INTVSTCK | X | X | X | X | ||
| INTVUSEC | X | X | X | X | ||
| INTV16US | X | X | X | X | ||
| PCT | X | X | X | X | ||
| PCT3 | X | X | X | X | ||
| RATE | X | X | X | X | ||
| RATE3 | X | X | X | X | ||
| RATIO | X | X | X | X | ||
| RESTYPE | X | X | ||||
| SCLOCK | X | X | X | X | ||
| SCLOCK12 | X | X | X | X | ||
| SUM | X | X | X | X | ||
| SUM3 | X | X | X | X | ||
| TEXT | X | X | X | |||
| TIMESTP | X | X | ||||
