November 10, 2005, 10:01 PM
Sheila G. WhitcherCOMMA DELIMITED FILE CONSTRAINTS
I have a comma delimited file that I want to read using WebFOCUS (5.3.3). The output is 6000 bytes long and these are broken into 1274 fields. Currently working on getting a master file description created to read the file. Are there any size constraints that could cause problems?
November 18, 2005, 10:00 AM
KerryHi Sheila,
Per the online documents, the maximum file size for a COMMA delimited file is 256KB. The following topics from Information Builders' online documents may be of interest as well:
Differences between PCHOLD FORMAT LOTUS and COMMA?
http://techsupport.informationbuilders.com/sps/70921046.htmlHow to use ON TABLE HOLD to create a comma delimited file
http://techsupport.informationbuilders.com/sps/11362044.htmlHow to read Comma Delimited files in WebFOCUS?
http://techsupport.informationbuilders.com/sps/10122056.htmlRestrictions for FORMAT COMMA,COMT,COM.
http://techsupport.informationbuilders.com/sps/12912013.htmlHope this helps.
Cheers,
Kerry