Skip to Content

Formatting report output

A PRL report is formatted according to the parameters specified with the SET and USING statements.

SET can be used to size and title the report and to define a variable to be reported. USING specifies the CMRDETL, CTGDETL, and CMRSTATS records to be reported as reformatted by the BBPLIB data dictionary. For more information, see Reference-for-PERFORMANCE-REPORTER. The data dictionary descriptions for each record field are printed as column headings with each specified field name.

Related topic

PRL-programming-techniques

Predefined data dictionary descriptions

PERFORMANCE REPORTER provides a data dictionary in a partitioned data set called BBPLIB that automatically creates column headings for the CMRDETL, CTGDETL, and CMRSTATS record fields specified with the PRL.

A description of each CMRDETL, CTGDETL, and CMRSTATS record field is stored in the data dictionary. These descriptions are used in the report as column headings.

The USING statement (see USING-designate-column-headings-and-record-fields) and the field names of a CMRDETL, CTGDETL, or CMRSTATS record. For more information about how to specify the data dictionary headings to be printed, see Reference-for-PERFORMANCE-REPORTER.

Information
Example

For example, as shown in the Time-versus-activity-graph, the following specification selects the CMRSTATS type CC record and specifies the data dictionary descriptions for the CMRDATE, CMRTIME, and T6FTRNCT fields:

SELECT TYPE CC RECORDS FROM CMRSTATS
        .
        .
        .
USING CMRDATE CMRTIME T6FTRNCT
REPORT

END

The CMRDATE, CMRTIME, and T6FTRNCT fields correspond to the following column headings:

RECORDED DATE

RECORDED TIME

TOTAL TASKS

User-defined data

To define data to be reported, assign a value to a variable, and then specify the variable with the USING statement.

Information
Example

For example, the following specification prints the variable name, TRANTERM, as a column heading, and its assigned value as the column contents:

SELECT TYPE 6E RECORDS FROM CMRDETL
        .
        .
SET TRANTERM = '&T6ETRID.  &T6ETMID'

USING TRANTERM
        .
        .
REPORT

END

The transaction identifier (&T6ETRID field of the CMRDETL record) and the terminal identifier (&T6ETMID field of the CMRDETL record) are reported in the TRANTERM column.

The variable name must start with an alphabetic character and can comprise any alphanumeric string up to a maximum of eight characters. If the name is longer than the width of the column data, the name is truncated to the column width.

PERFORMANCE REPORTER right-justifies user-defined headings and adds two blank characters at the beginning of the column heading. The column headings can be aligned with the column data either by examining the BBPLIB data dictionary or running the report. The printed report shows where to align the headings. The character string assigned to a column heading variable can then be adjusted to the width of the column data. Or the BBPLIB data dictionary can be examined for the length and type of each CMRDETL, CTGDETL, or CMRSTATS field, which together determine the column width. For a description of the type key definition, see Reference-for-PERFORMANCE-REPORTER.

.


 

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

BMC AMI Ops Monitor for CICS 7.3