HDB Report command

The HDB(REPORT) operand requests CICS PA to generate reports from HDB data. The command applies to both List and Summary HDBs.

The command format is:
CICSPA HDB(REPORT(hdbname),
          [OUTPUT(ddname),]
          [TOTALS(n)|NOTOTALS,]
          [INTERVAL(hh:mm:ss),]
          [FIELDS(field1[(options)],...),]
          [LINECount(nnn),]
          [SELECT(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),...)),]
          [SELECT2(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),...))])
The options are:
REPORT
Specifies the name of the HDB to report against. The HDB must be defined in the HDB Register (DDname CPAHDBRG).
OUTPUT
DDname for the report output. If not specified, CICS PA assigns a DDname in the format HDBRnnnn where nnnn is the report sequence number 0001-9999 to uniquely identify the output.
NOTOTALS|TOTALS(n)
The totals level applies only to the Start of changeSummaryEnd of change report.

Specify TOTALS(1) to TOTALS(8) to accumulate subtotals for up to 8 sort fields, print the subtotals when the sort field changes, and print a grand total at the end of the report. Default: TOTALS(8)

Specify TOTALS(0) for no subtotals, but print only the grand total.

Specify NOTOTALS for neither subtotals nor grand total.

INTERVAL
Specify an optional Time Interval when reporting Summary HDBs. The default is the Time Interval used to create the data (as defined in the Template). In our example, Template PRODSUM used to create the HDB data specified 15 minutes.

You can specify any interval greater than or equal to the Template Interval. For example, if you are reviewing many days worth of data then you might specify 24:00:00 (24 hours) so that you can view the daily trend. In the example above, the Interval has been changed to 1 hour.

FIELDS
Specifies which fields are reported, the order in which they appear in the report, and their summarization presentation. Only fields that are specified in the HDB Template can be specified. Fields not contained in the HDB are reported as Missing.
LINECount
Controls the number of lines per page in the HDB report.
SELECT, SELECT2
Specifies what data to include or exclude from the report based on data field values.

SELECT and SELECT2 can both be specified to perform record filtering. The CICS PA dialog generates SELECT2 statements in the command deck when you use a Report Form that has active Selection Criteria. If both SELECT and SELECT2 are specified, then the record must pass selection by both specifications for it to be included in the report.