The general format of the SELECT statement for CMF performance
class records is:
SELECT(PERFORMANCE(EXCLUDE|INCLUDE(
[ACTIVE|START|STOP(FROM(date,time),TO(date,time)),]
[char-fieldname(text string),]
[count-fieldname(value list),]
[decimal-fieldname(value list),]
[clock-fieldname(TIME|COUNT(value list)),]
[CHARACTER(
OWNER(owner),SUBSTR(offset,length),VALUE(value list)),]
[CLOCKTIME|CLOCKCOUNT|COUNT(
OWNER(owner),NUMBER(nnn),VALUE(value list))])))
CMF record data fields are defined as specific types. Each field
type has a particular format in the SELECT statement:
- ACTIVE, START, STOP time stamp fields require at least one FROM
or TO operand. The format of (date,time) can be either:
- (yyyy/mm/dd,hh:mm:ss.th) or (-n,hh:mm:ss.th) or
- (yyyy/mm/dd,) or (-n,) or
- (,hh:mm:ss.th)
If both FROM and TO dates are specified, they must be in
the same format; both must be calendar dates or both must be relative
dates.
- Values for character fields are specified as text strings.
For each character field, a maximum of 200 characters can be specified.
A text string can be entered either alone or in a list:
- (text) or
- (text1,text2,text3)
- Values for count and time fields are specified as value lists.
For count fields, specify positive integers from 0 to 999999999.
For time fields, specify values as thousandths of a second (or seconds
if you specify the number with a decimal point).
A value list
can be made up of individual values, ranges, or both. Up to 30 values
or ranges can be specified. For example:
- (value)
- (value1-value2)
- (value1,value2,value3)
- (value1-value2,value3-value4,value5-value6)
- (value1,value2-value3,value4)
Alternatively you can precede the From value
in the range with a comparison operator. For example, specify >=1
for a comparison of greater than or equal to 1. Allowed operators
are:
= > >= < <=
Specify time values in seconds (using a decimal point)
or milliseconds. For example, we can request RESPONSE in the range
1.12 to 1.25 seconds or the equivalent 1120 to 1250 milliseconds.
- CICS-defined clock type fields require either the TIME or COUNT
operand.
- CHARACTER user fields require the OWNER, SUBSTR, and VALUE operands.
Decimal fields such as CPUSU require a value to
be entered that includes the decimal point, for example 12.5 or 10.0. 
- CLOCKTIME, CLOCKCOUNT, COUNT user fields require the OWNER, NUMBER,
and VALUE operands.
- See Fields by forms, HDB templates for the name
and format of the CICS-defined fields that can be specified in SELECT(PERFORMANCE statements.