SELECT(EXCEPTION

The general format of the SELECT statement for CMF exception class records is:
SELECT(EXCEPTION(EXCLUDE|INCLUDE(
           [ACTIVE|START|STOP(FROM(date,time),TO(date,time)),]
           [char-fieldname(text string),]
           [numeric-fieldname(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 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.


Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


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