CSV and XML File Production › CSV Record Types › The Data Record

The Data Record

The third record type is the Data record. Data records begin with the third record of the member and continue to the end of the file. The data records contain data values derived from either the detail or summary lines of the CA JARS or CA Earl reports, depending on the type of report being produced. Data records contain as many values as there are data elements in the dictionary record. Character fields are delimited by double quotes while numeric data is not quoted. Numeric values that are negative are preceded by the minus (-) sign. In addition, the CURRENCY symbol (Default $) is removed from numerical data in the data record. The CURRENCY symbol to be removed is set by the user through the use of the CURRENCY setting on the OPTION control statement for CA JARS reports, or through the 'EURO=.$' statement for CA Earl users. In addition, all commas are removed from numeric data, but decimal points are left intact. CSV files contain only detail or summary data depending on the type of report requested. Control break lines that appear on printed reports are not reflected in the CSV files. For CA JARS reports, if two levels of descript processing are in effect for a report, the SUB-ID column appears in the dictionary record and this identifies the column heading. The data records contain the control break values from the descript cards. The following is an example of a CSV PDS member.

 "HCSV","0000","JARS","C.0","19980903","160602","CSVTST16","CAI","JARS",9,0000,"K1D1"," ",
 "JOB NAME","NBR JOBS","NBR SESSNS","SERVICE UNITS","USER INFO","ALLOC TME-AVG","ACT TME-AVG","CPU
 "CAS9",1,0,59001," ","00:00:04","00:02:28","00:00:04","00:00:04"
 "CLEANSYS",4,0,397382," ","00:00:09","00:03:56","00:00:06","00:00:25"
 "FONGW01",0,1,262023," ","00:00:01","00:03:31","00:00:10","00:00:10"
 "FONGW01E",4,0,15566," ","00:00:03","00:00:16","00:00:00","00:00:01"
 "JRDR",6,0,11263," ","00:00:00","00:00:10","00:00:00","00:00:01"
 "LLA",5,0,972334," ","00:00:02","03:41:58","00:00:05","00:00:25"
 "SMFDMP",1,0,10090," ","00:04:16","00:00:08","00:00:01","00:00:01"
 "SMFE",7,0,7334," ","00:00:03","00:00:04","00:00:00","00:00:00"
 "SMFG",3,0,3128," ","00:00:00","00:00:02","00:00:00","00:00:00"

Note: The CSV format used by CA JARS is compatible with the CSV file format created by CA MICS and the CA Query and Reporting Workstation product.