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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
That doesn't seem to work here, not sure why as we're on v7.7.04 as well. We use FOCCACHE all the time, so it's certainly enabled...
WHENCE inc_amp FOCEXEC
Results in: (FOC1892) FILE NOT FOUND : inc_amp FOCEXEC
Anyway, intriguing feature. I had been wondering whether it would be possible to obtain a list of parameters like this to aid in creating/maintaining drilldown parameter lists by simply modifying a copy of the parameter list of the current procedure.
For example, creating EXL2K output for the current report could then be done by something similar to:
Of course, the current list of params isn't formatted correctly for using directly in a STYLE declaration. It would also be convenient to be able to prune parameters from that list that aren't needed in the drilldown (or that are to be replaced with the same parameter(s) with a different value).
Any chance this could work something like this?:
-? & HOLD FOCCACHE/paramList
TABLE FILE paramList
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
This is a brilliant technique for a quick way to save/retrieve all parms. But, I am looking for a way to save all parms as fields in a .foc or some table to retrieve in future. Almost like buidling Save Selection on Portal. Please advise if theres an easy way. I have a not so elegant way to create define for each parm and PRINT/HOLD and then keep appending by -MORE as we different users run diff selection.