Comma-separated reports (HPCACSV)

The comma-separated report, which is in CSV format, is similar to the columnar report in content and in sequence.

However, the fields in this report are stripped of trailing blanks and separated by commas. The CSV format can be loaded directly by most commercially available spreadsheet programs and is appropriate for performing additional sorting, totaling, or search analysis.

The following table shows the commands available for generating comma-separated reports:

Table 1. Commands for generating comma-separated reports
Command Function
RPT.ORDER=DBD/GROUP/CC Specifies the sort sequence
HPCACSV DD Specifies that the report output should be directed to HPCACSV

Report order determines both the sequence of lines within the report and the sequence of fields within the line. Report order includes the following options:

  • DBD = DBD,DDN,NUM,GROUP,DATE,TIME ...
  • GROUP = GROUP,DATE,TIME,DBD,DDN,NUM ...
  • CC = CC,GROUP,DATE,TIME,DBD,DDN,NUM ...

The default order is DBD.

The following example shows a comma-separated report:

Figure 1. Sample comma-separated report (HPCACSV)
Start of change
DBDNAME,DDNAME,NUM,CA GROUP,DATE,TIME,DFSULOG,DFSUCUMO,DFSUCUMN,PURGE,CC,DBRC           
                                                                                        
DBVHDJ05,CJVHDG1E,1,CAGRP1,24.074,02:01:47.1,000000817,000000000,000000010,24064022356569701+0000,0000,N
End of change

Start of changeSee Columnar reports (HPCACOLP and HPCACOLS) for the description of each field. End of change