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.