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),]
           Start of change [decimal-fieldname(value list),] End of change
           [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:
  1. 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.

  2. 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)
  3. 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.

  4. CICS-defined clock type fields require either the TIME or COUNT operand.
  5. CHARACTER user fields require the OWNER, SUBSTR, and VALUE operands.
  6. Start of change Decimal fields such as CPUSU require a value to be entered that includes the decimal point, for example 12.5 or 10.0. End of change
  7. CLOCKTIME, CLOCKCOUNT, COUNT user fields require the OWNER, NUMBER, and VALUE operands.
  8. See Fields by forms, HDB templates for the name and format of the CICS-defined fields that can be specified in SELECT(PERFORMANCE statements.

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///users-guide/selperf.htm