Report writer - 'E' exponential values in CSV output file.

Products

• SYSVIEW Performance Management
• NXBRIDGE - SYSVIEW/ENDEVOR

Issue/Introduction

During creation and export(to CSV) reports, getting in CSV output file fields with exponential values 'E'. 

Producing a transaction report(CTRANLOG) in the CSV output file see values with 'E' notation, like in the example below.   

Example: 

LIFETIME

2.03E+04

Environment

Release : 16.0

Component : SYSVIEW

Cause

Length of the output value. 

Resolution

Use FORMAT option which will help to define the length of an output field or to specify how many decimal positions it contains.

 

Example:

 

TAB2 CTSD_TRAN                              HDR1( ) HDR2(TRAN    ),   
CICS SUM TRAN CTSD_COUNT HDR1( ) HDR2(COUNT   )FORMAT(NNNNNN.NN)  AND   

 

NOTE: To have enough space for FORMAT parameter, abbreviations could be used.  

Additional Information

Documentation: https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-mainframe-software/performance-and-storage/ca-sysview-performance-management/16-0/reporting/using-ca-explore-report-writer/valid-variable-options/format-option.html