search cancel

CA-Endevor CSV Reporting File and the NOCSV Option

book

Article ID: 21003

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS PanAudit Plus Easytrieve Report Generator PAN/SQL Endevor Software Change Manager (SCM) Endevor Software Change Manager - Natural Integration (SCM) Endevor Software Change Manager - ECLIPSE Plugin (SCM) Endevor Software Change Manager - Enterprise Workbench (SCM) CA 2E

Issue/Introduction

Description:

In the CSV reporting utility there is an option called NOCSV which will generate raw data for use within a customer's program. The general consensus was that the data produced via the option NOCSV was the same as when not using the option; well that is wrong, the data is not the same.

Solution:

In the CSV reporting utility there is an option called NOCSV which will generate raw data for use within a customer's program. The general consensus was that the data produced via the option NOCSV was the same as when not using the option; well that is wrong, the data is not the same.

The purpose of the CSV file and NOCSV file are different. The main purpose of the CSV file is to be able to be uploaded in excel format and to be reported upon by tools that can read .CSV or .XLS(x) extensions. The purpose of the file created using the NOCSV option is to supply the raw data to be used in a customer's program and handle according to the program's needs.

Example of the one area that does not match up: Package Back-out Y/N , as result of the LIST ELEMENT function.

In the NOCSV format the output represents the data as it appears in the MCF record:

 	2012122405021602PKGA 2012122405020725PKGA 

In the CSV format this becomes:

 	"PKGA","2012/12/21","05:02:16:02","Y","PKGA","2012/12/12","05"02:07:25" 

One can see that the CSV data has been reformatted, not in the same order and the "Y" has been added to the CSV format to indicate that package is backed-out. In the CSV file the "Y" is in column "CH".

Now the question becomes how does the CSV Utility determine that a package is backed-out?

Answer: It compares the source package and target package name and timestamp. If they match the PKG is not 'backed-out'.

Environment

Release: ENDAE.00200-15.1-Endevor-Software Change Manager
Component: