Can a Log Analyzer report be created in Comma Separated Values CSV format

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

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?

Resolution

Reference the GENFILE CSV option within the Log Analyzer documentation:

DMLREPT Control Statement

From the link scroll down to the GENFILE Parameters section and note:

,GENFILE(FIXED|VARIABLE
        ,UTILITY(APPLY|LOAD|FLOAD|CSV)

The following is what is documented for the UTILITY options:

UTILITY (APPLY|LOAD|FLOAD|CSV)
Generates the following items:

APPLY
Generates the control statements to run the Log Apply utility.

LOAD
Generates the control statements to run a Db2 load utility.

FLOAD
Generates the control statements to run the Fast Load utility.

CSV
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:
"DSN8C10";"EMP";"I";"000010";"JANE";"E";"DOE";"A00";"3978";19.....

 

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:

,UTILITY (CSV)