ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 187547

calendar_today

Updated On:

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

Cause

Length of the output value. 

Environment

Release : 16.0

Component : SYSVIEW

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