 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] TABLE FILE from comma delimited file
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] TABLE FILE from comma delimited file Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] TABLE FILE from comma delimited file | Login/Join |
| Platinum Member |
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 * ENDThis message has been edited. Last edited by: Mark1, Windows version 768 | ||
|
| Expert |
Shouldn't your slashes be \ instead of /. What happens, what error message or results ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
I get the FILE MYFILE CANNOT BE FOUND. But I can see it there with windows explorer. Windows version 768 | |||
|
| Expert |
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?
| |||||
|
| Platinum Member |
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 | |||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
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 | |||
|
| Expert |
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...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
OK, thanks! I appreciate the help. Windows version 768 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] TABLE FILE from comma delimited file
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] TABLE FILE from comma delimited fileCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |