Focal Point
[CLOSED]Need to display column header in CSV format

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1781022142

August 10, 2007, 09:12 AM
Suji
[CLOSED]Need to display column header in CSV format
I can not display column header information in my report using format COMT.Can anyone suggest me any workaround for this issue?

Suji

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
August 10, 2007, 09:53 AM
Leah
The only solution I've seen is to define a field in request that looks like the same format as the comt file and write it out first.

Define...
headline/axxx = '"xxx"' | 'xxx' |
and so on


Leah
August 10, 2007, 09:55 AM
Francis Mariani
Column titles print just fine with COMT:
FILEDEF H001 DISK C:\TEMP\H001.CSV
-RUN
TABLE FILE CAR
PRINT
*
ON TABLE HOLD AS H001 FORMAT COMT
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 10, 2007, 10:34 AM
Suji
Leah,
Can you please give me one example for this format.

headline/axxx = '"xxx"' | 'xxx' |


WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
August 10, 2007, 12:14 PM
Leah
quote:
FILEDEF H001 DISK C:\TEMP\H001.CSV
-RUN
TABLE FILE CAR
PRINT
*
ON TABLE HOLD AS H001 FORMAT COMT
END


Thanks for the example, though, I've seen questions elsewhere with having just such an issue when using mainframe FOCUS which I no longer have access to. Is it consistent across platforms.


Leah
November 04, 2015, 05:12 AM
Kartik Katyal
SUJI, DID YOU FIND A SOLUTION TO THIS? PLEASE SHARE IF YOU DID.


WebFOCUS 8010,8204
Windows