Can the Endevor CSV be used to list components

Products

• Endevor
• Endevor Natural Integration
• Endevor - ECLIPSE Plugin
• Endevor - Enterprise Workbench

Issue/Introduction

Can the Endevor CSV format be used to show copybooks and/or components associated to elements 

 

Environment

Release : 18.1

Component : CA Endevor Software Change Manager

Resolution

The CSV Utility can be used to list component information.  The below JCL is an example that you can modify to your needs.  

//* YOUR JOBCARD GOES HERE **// 
//************************************* 
//* DELETE CSV LIBRARY 
//************************************* 
//STEP1 EXEC PGM=IDCAMS 
//SYSPRINT DD SYSOUT=* 
//SYSIN DD * 
DELETE 'IPRFX.IQUAL.COBOL.CSV' 
//********************************************* 
//* SPECIFY ELEMENT NAME WITH SEARCH * 
//********************************************* 
//STEP1 EXEC PGM=NDVRC1,REGION=4M, 
//   PARM='CONCALL,DDN:CONLIB,BC1PCSV0' 
//STEPLIB DD DISP=SHR,DSN=YOUR.ENDEVOR.CSIQAUTU 
//        DD DISP=SHR,DSN=YOUR.ENDEVOR.CSIQAUTH 
//CONLIB  DD DISP=SHR,DSN=YOUR.ENDEVOR.CSIQLOAD 
//C1MSGS1 DD SYSOUT=*
//CSVLST1 DD DSN=IPRFX.IQUAL.COBOL.CSV, 
//   DISP=(NEW,CATLG,DELETE), 
//   DCB=(DSORG=PS,RECFM=VB,LRECL=4092,BLKSIZE=4096), 
//   SPACE=(CYL,(800,500),RLSE) 
//BSTERR   DD SYSOUT=* 
//SYSUDUMP DD SYSOUT=* 
//BSTIPT01 DD *                 
  LIST  COMPONENTS USED BY ELEMENT *                         
   FROM ENV eviron                                              
        SYS system                                           
        SUB subsys                                           
        TYP COBOL                                             
        STA 1                                                 
   TO FILE CSVLST  .    

 

Once the information is generated, a file is created that looks something like this: 

"RCD TYPE","CMPNT LL","CIRCULAR","INDIRECT","RELATED","ELM NAME","TYPE NAME","EN
"1","01"," "," "," ","APITEST","COBOL","environ","system","subsys","1","1","STG1"
"2","02"," "," "," "," "," "," "," "," "," "," "," ","APITEST","iprfx.iqual.STG1
"1","02"," "," "," ","ECCCNST","COBCOPY","environ","system","GA","2"," "," "," "," 
"1","02"," "," "," ","ECHAACTL","COBCOPY","environ","system","GA","2"," "," "," ","
"1","02"," "," "," ","ECHAEPRM","COBCOPY","environ","system","GA","2"," "," "," ","

The report information (Sequential file) must now be downloaded and saved to your desktop. Make sure that the file named for this case COMP_LIST.csv. This step can be done using a variety of different download utilities. Regardless of what utility used, be sure to specify the following values:

• ASCII/EBCDIC: Enable this option to translate the file from EBCDIC (IBM Host character set) to ASCII (PC character set) while downloading the file. This option is required when transferring text file.
• CRLF: Converts the "end of record' character from the host file to carriage returns and line feeds in the PC file. This option is required when transferring text files.
• TSO: Select the appropriate operating system that your host is running

After the information is downloaded to your desktop, double click on the file "ELEMENT_LIST.csv" and it will open as an EXECL Spreadsheet. If for some reason this does not work, import the file into the tool that you will be using to generate your report. For example, to import the data into an Excel spreadsheet, follow these steps:

1. Start Excel
2. From the Data Menu, select Get External Data, then select from text
3. The Import test file dialog opens. select the file you downloaded, then click import
4. The Text Import Wizard Step 1 of 3 dialog opens. Select Delimited and click Next
5. The Text Import Wizard Step 2 of 3 dialog opens. De-select Tab, select comma, and click Next
6. The Text Import Wizard Step 3 of 3 dialog opens. Select text select finish
7. Select either existing worksheet or new worksheet then select ok

The information that was retrieved will now look like this in the Excel spreadsheet:

The first four columns provide the type of record, component level, and what type of component it is. 

RCD TYPE - The type of entity for this response is:

1-Footprinted element

2-Non-footprinted member

3-Related element

4-Related member

5-Related object

6-Related comment

CMPNT LL - Current component level number. Maximum field length is two characters. 

CIRCULAR - Indicates whether the component is circular. Maximum field length is one character. 

INDIRECTI - Indicates whether the component is indirect. Maximum field length is one character. 

RELATED - Indicates whether the component is related. Maximum field length is one character.