There is an alternative for merging 2 or more CSV extracts for reporting. This alternative is provided by the use of the "Table Tool", and the report can be produced in one job. Everyone who owns Endevor, has the Table Tool.
The output from the first CSV utility is formatted by Table Tool into a REXX stem array (a very cheap database-like structure). Then, the Table Tool step that reads the second CSV also fetches data from the REXX stem array, and affectively merges data from the two CSV outputs onto a report.
See Example #5 in the Table Tool Examples for a simple example, where a list of members is converted into a REXX stem arrary.
https://community.broadcom.com/mainframesoftware/communities/community-home/librarydocuments/viewdocument?DocumentKey=05418f74-32b8-4ca2-a777-7e4dd7ddc614&CommunityKey=592eb6c9-73f7-460f-9aa9-e5194cdafcd2&tab=librarydocuments
Below is another example, where Endevor package shipping CSV data is converted by Table Tool into a Rexx stem array.
In this example, the output DSN=&&SHIPDATA is used as an input OPTIONS by a subsequent step.
//*---------------------------------------------------------------------
//*-- Save Shipment info in a format for next step
//*---------------------------------------------------------------------
//STEP6 EXEC PGM=IRXJCL,PARM='ENBPIU00 A'
//TABLE DD DSN=&&APISHIP,DISP=(OLD,DELETE)
//SYSEXEC DD DISP=SHR,DSN=MYHLQ.ADMINT.REX
// DD DISP=SHR,DSN=MYHLQ.ADMINP.REX
//STEPLIB DD DISP=SHR,DSN=&STEPLIB
//OPTIONS DD *
$Table_Type = "CSV"
//MODEL DD *
Shipment.&PKG_ID = "&DEST_ID &RMT_MOVE_RC"
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//TBLOUT DD DSN=&&SHIPDATA,
// DCB=(DSORG=PS,RECFM=FB,LRECL=80),
// DISP=(NEW,PASS),
// SPACE=(TRK,(1,1),RLSE)
Original Message:
Sent: 11-22-2019 11:08 AM
From: Felicity Vaughan
Subject: REPORTING
Yep – that's what I came up with. Just wanted to see if there was some other 'ultra clever' way to do this. Thanks John.
Original Message------
Seems to me the only way of getting what you want is to do 2 different CSV extracts and merge them together either in Excel or an upload to DB2 and using a SQL JOIN action based on a common field.
The 2 CSV extracts I suggest are the LIST SMF CSV and the LIST PACKAGE ACTION CSV.
I have to admit that it is odd that the Package ID is not saved in the SMF record given its relation to audit requirements.......
------------------------------
Consultant
John D Consulting Inc.
------------------------------