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.