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

Document ID : KB000048854
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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.

Solution:

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:

Figure 1

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.