We are trying to replace some of our current CICS statistical reporting with report writer. It is an hourly report showing the CICS transaction volume along with some other fields. We are using Tab and TAB2 to build the report. The issue we are having is that fields that have duplicate values like date,time, applid and lpar are not written to the next row of data. Is there a way to have the date, time, applid or any duplicate data written to the next row of data. We also want to convert this data to a CSV, but the duplicate values do not show there either, we just get the 4 ',' seperators.
The commands we use in the report are -
COPY GSVSMF27
OPTION(MAXTO=NO,SUMMARY=NO,LEAPSEC=1)
LINECOUNT 999
DEFINE ID MRO APPLID(5,4)
SELECT TRANID(¬CD*,¬CF*,¬CSK*,¬CSS*,¬CW*)
TAB DATETIME MRO HDR1() HDR2(Applid),
C_LPARNAME HDR1() HDR2(LPAR) SORT ALPHA
TAB2 TRANID HDR1() HDR2(Trans*Name) SORT ALPHA AND,
TRAN USE FORMAT(NNNNNNN) HDR1() HDR2(Trans*Volume) AND,
TRAN CPU HDR1() HDR2(Average*CPU) AND,
TRAN LIFE HDR1() HDR2(Average*Response*(SEC)) AND,
TRAN MAXLIFE HDR1() HDR2(Max*Response*(SEC))
EACH HOUR
END
RUN
The Report Writer output looks like this, with blank fields in each row for a duplicate value -
The CSV output looks like this -