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.

The syntax of a summary expression is:
Read syntax diagramSkip visual syntax diagram
Summary Expression

   .------------------------.      
   |            .-,----.    |      
   V            V      |    |      
>>---sumopt--(----attr-+--)-+--.-------------------------------><

where:
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.
You can specify the same summary option more than once in a summary expression.
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.
Note: A summary expression must be followed by either blank spaces or null characters to the end of the specified buffer. That is, the buffer length you specify (using the LENGTH option) should not include any data other than a summary expression.
For example, you could use a summary expression like this when grouping LOCTRAN records:
  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.

Table 1.
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  


eyup1bb.html | Timestamp icon Last updated: Sunday, 4 June 2017