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,]
          Start of change [SUFACTOR(hdbname(nnnnn.nnn)),] End of change
          [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 Repository (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 Summary 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.

Start of change SUFACTOR End of change
Start of change

Specifies a CPU SU conversion factor to apply to the HDB records. The SUFACTOR operand includes two keywords to identify the HDB name and its associated conversion factor. The value must be a decimal number or integer in the range 1 - 999999999 (nine 9s).

End of change
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).

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.

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.


Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///report-reference/cparr196.htm