Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to write the file from the database
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] How to write the file from the database
 Login/Join
 
Silver Member
posted
Hi Everyone

I need to write the file including column header with comma(,) or pipe(|) delimiter from the table using webfocus.

for example output should be:

S.No|S_Name|S_Address1|S_Address2|S_Phone_no
1|xxxx|dvhv|dhvg|98840
2|yyyy|fsgf|cfhsdjf|30788

Please help me, we are struggling more on this

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 35 | Registered: February 17, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
Use ON TABLE HOLD FORMAT DFIX

You can search for DFIX on the help files - here

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5601 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
http://forums.informationbuild...1057331/m/9391009003

Actually, what Tony there said DFIX is the way to go:

TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT DFIX DELIMITER | ENCLOSURE " HEADER YES
END

Or what was in your example, you can leave that ENCLOSURE " away.

This message has been edited. Last edited by: Hank W.,


Cheers,
H.

WebFOCUS 8.1.05M
Oracle 11g - DB2
RedHat
 
Posts: 114 | Location: Brighton UK | Registered: February 19, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to write the file from the database

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.