I need to write the file including column header with comma(,) or pipe(|) delimiter from the table using webfocus.
for example output should be:
Please help me, we are struggling more on thisThis message has been edited. Last edited by: FP Mod Chuck,
Windows, All Outputs
Use ON TABLE HOLD FORMAT DFIX
You can search for DFIX on the help files - here
Well, FORMAT COMT gives you a bogstandard .csv file with the titles.
If you need something more exotic, and you need to use some masking then you might want to look at
Actually, what Tony there said DFIX is the way to go:
TABLE FILE CAR
ON TABLE PCHOLD FORMAT DFIX DELIMITER | ENCLOSURE " HEADER YES
Or what was in your example, you can leave that ENCLOSURE " away.This message has been edited. Last edited by: Hank W.,
Oracle 11g - DB2
|Powered by Social Strata|