Using the DATA clause of the Endevor CSV Utility LIST ELEMENT function to obtain change statistics.

Products

• Endevor
• Endevor - Enterprise Workbench

Issue/Introduction

The DATA clause of the LIST Element function of the CSV Utility offers the possibility to obtain Change statistics of levels of selected elements, as well
as their CCID's and COMMENT's.

Resolution

To obtain the change statistics of elements, one can use the CSV Utility with the DATA ELEMENT CHANGE LEVEL SUMMARY clause in the LIST ELEMENT.

For example:

//CSVIPT01 DD *       
 LIST ELEMENT * 
 FROM ENV ENV1 SYSTEM * SUB * TYPE * STAGE *
 DATA ELEMENT CHANGE LEVEL SUMMARY
 OPTION PATH PHYSICAL RETURN ALL SEARCH

 

The result (defaults to the APIEXTR DD), will be a comma separated file, that can then be input as such into a spreadsheet program.

A snip of how the spreadsheet results look as illustration:

The #STMNTS, #INSERT and #DELETE reflect the changes to a particular change level of the elements.

The CCID and COMMENT columns reflect those of each change level of the element, including that of the Base element.

Note: Especially if a large number of elements will be selected, it can be useful to run the CSV Utility with OPTION NOCSV.

This also produces a record per element, however it is not comma separated, and the various data fields are present in fixed columns.

This makes it possible to process (eg. Sort) the file while still on the Mainframe.