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 TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
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.
I want to deliver an ALPHA data file output option to users under MR deferred reports. v7.6.9. I use this command in the fex: ON TABLE PCHOLD FORMAT ALPHA. When I retrieve the report using the View button on the deferred reports list the dialogue shows this:
MIME Type: application/x-ftm Description: UnKnown Windows does not recognize this MIME type.
The window dialog shows FIND and SAVE button options and the SAVE filename is "WFSERVLET" with no file extension.
How do I associate this ALPHA output format with a known file type extention like .txt? Thanks in advance. --MikeThis message has been edited. Last edited by: Kerry,
WebFocus 7.7 Windows/SQL and Z/OS with DB2 Excel, HTML, PDF, etc.
1. Save hold file. 2. Embed the hold file into HTMLFORM=TEXT The deferred report View button opens the file into the browser where the user can save-as a text file.
(We made the .txt filename dynamically unique to avoid user conflicts.) Here is sample code:
FILEDEF OUTPUT1 DISK ourfolder/&dynfilename.EVAL.TXT
TABLE FILE Our_File PRINT FIELD1 FIELD2 etc... BY FIELD1 NOPRINT WHERE FIELD1 EQ 'YADA YADA' ON TABLE HOLD AS OUTPUT1 FORMAT ALPHA END
SET HTMLFORMTYPE=TEXT -HTMLFORM BEGIN !IBI.FIL.OUTPUT1; -HTMLFORM END
WebFocus 7.7 Windows/SQL and Z/OS with DB2 Excel, HTML, PDF, etc.