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:
- 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 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.