Request Log Analyzer for Db2 for z/OS (PLA) output to go to Excel.
Is is possible for PLA to produce a load format file in Comma Separated Values (CSV) format?
Release : 20.0
Component : Log Analyzer for DB2 for z/OS
Reference the GENFILE CSV option within the Log Analyzer documentation:
From the link scroll down to the GENFILE Parameters section and note:
The following is what is documented for the UTILITY options:
Generates the following items:
Generates the control statements to run the Log Apply utility.
Generates the control statements to run a Db2 load utility.
Generates the control statements to run the Fast Load utility.
Generates the data file in a form of Comma-Separated Values (CSV).
A file that is executed with option CSV provides an output with semicolons between the data blocks.
The following example shows a CSV output of a sample employee table insert. This sample does not include URID options:
From review of the PLA ISPF panels under DML Activity / Set LOAD Options ==> Y, the CSV option
does not appear so this is a batch only option where the PLA control cards would need to be manually modified to specify: