Previous Topic: Interfacing with JARS/OLF and CA PMA Chargeback

Next Topic: CSV Record Types


CSV and XML File Production

With CA JARS you can create CSV (comma separated value) files directly from the Report Writer, and the CA Earl Report Writer. Two new files are introduced with this feature, the CAIJSCSV file and the CAIJSIDX file. The CAIJSCSV file is a PDS that acts as a repository for the CSV files. The CAIJSIDX file is an index file that contains information about CSV files that have been created, and where they reside.

The CAIJSCSV CSV file is a PDS that is used by CA JARS or CA Earl as a repository for CSV files. The members of the PDS are named either through the SORT control statement from the user defined report which created them if using the Report Writer, or through the 'MEM=MEMNAME' statement if using the CA Earl Report Writer. The PDS is a variable blocked file with an LRECL of 512 bytes and a default BLKSIZE of 5124 bytes, which may be changed by the user through JCL. The CAIJSCSV PDS is defined as a GDG (Generation Data Group) type data set (recommended) to allow for repeated executions of CA JARS or CA Earl jobs that create CSV files (weekly, for example).

When a CSV file is produced, it is also possible to generate an XML Profile that describes the CSV data. This profile will have the same member name as indicated in the report generation, with the exception that the first three characters of the XML profile will be PRF. For example, if the CSV member name is REP10110, the XML Profile will be named PRF10110.

We recommend not using names beginning with PRF for CSV members. This profile is used by iCan Service Management Suite, and describes the CSV file that is produced so that it can process the CSV file correctly.