Tech Doc Search Tech Support User Forums WebFOCUS Newsletter Summit Education

IB - Developer Center    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] TABLE FILE from comma delimited file
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] TABLE FILE from comma delimited file
 Login/Join
 
Platinum Member
posted
What is wrong with my code? I'm trying to query information from a comma delimited file on a shared folder:

SET PCOMMA=ON
FILEDEF MYFILE DISK //HORSEISLAND/NETSHARE/MEDICAL/OOQ/SOLUTIONSWORLD/TEST/MYFILE.TXT
TABLE FILE MYFILE
PRINT *
END

This message has been edited. Last edited by: Mark1,


Windows version 768
 
Posts: 215 | Registered: March 16, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Shouldn't your slashes be \ instead of /.

What happens, what error message or results ?


Waz...

Prod:WebFOCUS 7.1.6Upgrade:WebFOCUS 7.6.12OS:UnixOutputs:PDF, CSV, Excel, TXT, XML, HTML
In Focus since 1984
Know The Code
 
Posts: 4351 | Location: Sydney, Great Southern Land | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I get the FILE MYFILE CANNOT BE FOUND. But I can see it there with windows explorer.


Windows version 768
 
Posts: 215 | Registered: March 16, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Do you have a Master set up to read "MYFILE"?

Is this a file allocation error or a filre read error? What's your &FOCERRNUM?


Yes, that's my real license plate, as seen in Tennessee.  In FOCUS Since 1983 ... WebFOCUS 8: Testng now. Going Live Real Soon.
  WebFOCUS Developers Studio Version 7.6.11, MRE, ReportCaster. Data Sources: 1010Data, Oracle. Misc: SQL, JavaScript, MS Office, etc...
  Platform/OS: Linux for x86 (Intel, AMD) 32 bit. * Mostly Unix with 1 report server cluster on 2 Windows servers (&FOCMODE=WINNT).
  Output Formats: PDF, HTML, AHTML, EXL2k, and whatever else they may want that we can provide.
 
Posts: 1676 | Location: Goodlettsville, TN (Dollar General) | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I get this error:

0(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED:
No data description can be found for the file requested. Check the
Master File Descriptions allocated or available, or the spelling of
the file name. If you are in Screen Painter, type IGNore to
continue, or any other input to return to TED.


I thought you could read in a text file and query from it without creating a master file.


Windows version 768
 
Posts: 215 | Registered: March 16, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
WebFOCUS requires a master for any file.

It is needed so WF knows what format the file is and therefore what module to call to read it.


Waz...

Prod:WebFOCUS 7.1.6Upgrade:WebFOCUS 7.6.12OS:UnixOutputs:PDF, CSV, Excel, TXT, XML, HTML
In Focus since 1984
Know The Code
 
Posts: 4351 | Location: Sydney, Great Southern Land | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Nope. Part of the "magic" of WebFOCUS is in the Master File Description. Any data read done through WebFOCUS will require a Master file description. You can create one "on the fly" in your fex (which there are many examples of in the forum) but it's recommended to create an MFD which can be re-used and you'll also need a FILEDEF in your code or a DATASET declaration in the MFD that points to the actual data file.

(No, SQL passthru doesn't require an MFD, but there is not SQL passthru for COM files.)


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
The interesting thing about SQL passthrough is that it uses the structure of the returning data to build a master (SQLOUT), which TABLE FILE needs.


Waz...

Prod:WebFOCUS 7.1.6Upgrade:WebFOCUS 7.6.12OS:UnixOutputs:PDF, CSV, Excel, TXT, XML, HTML
In Focus since 1984
Know The Code
 
Posts: 4351 | Location: Sydney, Great Southern Land | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
OK, thanks! I appreciate the help.


Windows version 768
 
Posts: 215 | Registered: March 16, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

IB - Developer Center    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] TABLE FILE from comma delimited file

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