The HDB(REPORT) operand requests CICS PA to generate reports from HDB data. The command applies to both List and Summary HDBs.
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),...),...))])
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.
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.
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.