Need a cross reference report that shows the Endevor package name, element and element vv.ll being executed
search cancel

Need a cross reference report that shows the Endevor package name, element and element vv.ll being executed

book

Article ID: 226618

calendar_today

Updated On:

Products

Endevor

Issue/Introduction

Does Endevor have a report or utility that can be used to correlate the specific version of an Element and its package information. The information shown in element screen is misleading.

Resolution

The CSV report will provide the cross reference information needed. The below JCL will create a sequential file that can be used to create an excel spreadsheet and filter the data as needed.

//*------------------------------------------------------------------- 
//* PACKAGE ACTION SUMMARY CSV                                               
//*------------------------------------------------------------------- 
//DELETE   EXEC PGM=IDCAMS                                             
//SYSPRINT   DD SYSOUT=*                                               
//SYSIN      DD *                                                      
  DELETE 'iprfx.iqual.PKG.SUMMARY.CSV'                                 
/*                                                                     
//*------------------------------------------------------------------- 
//*   STEP 2 -- EXECUTE CSV UTILITY                                    
//*------------------------------------------------------------------- 
//STEP2    EXEC PGM=NDVRC1,REGION=4M,                                  
//         PARM='CONCALL,DDN:CONLIB,BC1PCSV0'                          
//STEPLIB  DD DISP=SHR,DSN=iprfx.iqual.CSIQAUTU                       
//         DD DISP=SHR,DSN=iprfx.iqual.CSIQAUTH                       
//CONLIB   DD DISP=SHR,DSN=iprfx.iqual.CSIQLOAD                        
//LISTPKG  DD DSN=iprfx.iqual.PKG.SUMMARY.CSV,                         
//         DISP=(NEW,CATLG,DELETE),                                    
//         SPACE=(CYL,(5,50),RLSE),                                    
//         DCB=(DSORG=PS,RECFM=VB,LRECL=4092,BLKSIZE=4096)             
//C1MSGS1  DD SYSOUT=*                                                 
//BSTERR   DD SYSOUT=*                                                 
//BSTIPT01 DD *                                                        
  LIST PACKAGE ACTION                                                    
  TO FILE LISTPKG                                                        
  FROM PACKAGE ID PACKAGENAME                                            
  .                                                                     

This KD will step thru the process to create an Excel Spreadsheet of the data. 

Here is an example of what a filtered spreadsheet looks like for a particular package. 

PKG IDSCL STMT#SITE IDELM ACTAPPR REQ (S)VALIDATION REQ (S)LOC (S)ENV NAME (S)SYS NAME (S)SBS NAME (S)TYPE NAME (S)STG # (S)STG NAME (S)STG ID (S)VV.LL (S)ELM (S)
PACKAGE110GENERATEYYCENV1SYS1SUBS1COPY1STG111.05ELEMENT1
PACKAGE120GENERATEYYCENV1SYS1SUBS1TYPE11STG111TESTING_REVERSE
PACKAGE130GENERATEYYCENV1SYS1SUBS1TYPE21STG111UpperAndLowercase#123
PACKAGE140GENERATEYYCENV1SYS1SUBS1TYPE31STG111REALLYREALLYREALLYLONGFILENAME