SELECT (find record type)

SELECT chooses records from CMRDETL, CTGDETL, or CMRSTATS by the record type.

Optionally, the starting point of the SELECT can be qualified with a date and time.

Syntax

 SELECT TYPE xx RECORDS FROM dataSet
SELECT TYPE xx xx RECORDS FROM dataSet
SELECT TYPE xx AND xx RECORDS FROM dataSet
SELECT TYPE xx xx xx ... xx RECORDS FROM dataSet
SELECT ALL RECORDS FROM dataSet
SELECT TYPE xx RECORDS FROM dataSet STARTING AT time ON date

where

  • TYPE xx or ALL names the specific records to be used from the MainView for CICS CMRSTATS, CMRDETL, or CTGDETL data sets; xx is the hexadecimal identifier of the record as described in Collecting-report-data and shown in the MainView for CICS PERFORMANCE REPORTER Data Reference. As shown in the syntax example, more than one record type can be selected from a data set with a single SELECT statement. A maximum of nine record types can be specified on one line.

    ALL selects all record types from a single data set. The specified types of records must reside in the same data set. CMRDETL data sets contain Type 6E or Type 6D records. CTGDETL data sets contain Type 6F records. For the record types found in CMRSTATS data sets, see Chapter 3 of the MainView for CICS PERFORMANCE REPORTER Data Reference. A maximum of nine specific record types can be selected.

  • RECORDS FROM is a required clause.
  • dataSet can be either CMRSTATS, CMRDETL, or CTGDETL on tape or disk, as defined by the JCL. PERFORMANCE REPORTER searches the data set for a record ID that matches the value specified by SELECT TYPE xx and makes those records available for PRL processing.
  • STARTING AT time ON date specifies when reporting is to begin. MainView for CICS performance data is arranged in chronological order with date and time stamps. The date is always represented as mm/dd/yyyy and the time as hh:mm:ss. To concentrate on a particular time period, add this parameter on the end of the SELECT statement. The selection process will not start until the first record is found. Today’s date is given by using the variable ZDATE. The current time is given by the variable ZTIME.

For example, the following statement reports CICS activity since the start of business today:

SELECT TYPE CC RECORDS FROM CMRSTATS STARTING AT 08:00:00 ON &ZDATE

This job can be run on any day and the start date does not need to be changed.

Note

If records are to be selected from an archive tape, STARTING AT has no effect and should not be used. Records can be selected from an archive tape by using WHERE as follows:

ELECT TYPE CC RECORDS FROM CMRSTATS
   WHERE CMRDATE = '09/17/1998'

 

Usage

Only one SELECT control statement per CMRDETL, CTGDETL, or CMRSTATS per run can be specified in each PRL program. You could receive unpredictable results if you do use more than one SELECT control statement in your program.

Example

SET TITLE = 'D E T A I L     T R A N S A C T I O N    R O S T E R'
 SELECT TYPE 6E RECORDS FROM CMRDETL
   USING CMRDATE CMRTIME T6ERESP T6EFCWTC T6ETRID T6ENETNM
 REPORT
END

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*