SELECT(PERFORMANCE
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.