SELECT(LOGGER

The general format of the SELECT statement for System Logger records is:

SELECT(LOGGER(EXCLUDE|INCLUDE(
           [STOP(FROM(date,time),TO(date,time)),]
           [char-fieldname(text string),]
           [count-fieldname(value list),]
           [flag-fieldname(0|1),]

CMF record data fields are defined as specific types. Each field type has a particular format in the SELECT statement:

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 fields are specified as value lists.
Specify positive integers from 0 to 999999999.
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:
```
=   >   >=   <   <=
```
For the name and format of the System Logger fields that can be specified in SELECT(LOGGER statements, see the prompt list in the CICS® PA online dialog. For details, see Specifying Selection Criteria.