Using SELECT statements

SELECT statements are optionally specified for report and extract processing to filter CMF records or System Logger records based on the values in particular fields.

The SELECT statement is used to INCLUDE or EXCLUDE data for the requested reports and extracts. Data is selected according to the type of record (CMF PERFORMANCE, CMF EXCEPTION, LOGGER) and within that, the values in certain fields.

The format of the statement is:
SELECT(PERFORMANCE|EXCEPTION|LOGGER(
       INCLUDE|EXCLUDE(field1(values1),...),
       INCLUDE|EXCLUDE(field2(values2),...),
                 ...))

For the complete list of operands which can be used with SELECT to control the selection of records, see SELECT(PERFORMANCE and SELECT(EXCEPTION.

SELECT(PERFORMANCE and SELECT(EXCEPTION can be used as a global operand to control multiple reports and extracts, or as a report-level operand to control an individual report or extract. Any number of global or report-level SELECT statements can be used together in a command stream. SELECT(LOGGER can be used only to control an individual report or extract.

Note: The global SELECT criteria is not reset with the next CICSPA command, however:
  • A report-level SELECT takes precedence over global selection criteria for that specific report or extract only, after which the selection criteria specified on the global SELECT again takes effect.
  • The next global SELECT statement adds the new selection criteria to the previous selection criteria (it does not replace it).