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.
We are working on a task to display all MasterFiles available in the all application directories useig APP QUERY command. Remember there is no input to list out and need to display all .mas files by app folder.
Any suggestions would be helpful.This message has been edited. Last edited by: Kerry,
WebFOCUS 8103 Appstudio, Dev Studio MRE Client Windows 7, Serveron Unix. Excel, PDF, HTML,AHTML
Use APP LIST, followed by APP QUERY, using the output of APP LIST as the input for APP QUERY
APP LIST HOLD
TABLE FILE FOCAPPL
ON TABLE SAVE
-SET &APPLINE = ' ';
-REPEAT :LAB1 &LINES TIMES
-READ SAVE &APP.64
-SET &APPLINE = &APPLINE | ' ' | &APP ;
APP QUERY &APPLINE HOLD
TABLE FILE FOCAPPQ
IF FILENAME CONTAINS '.mas'
Alan. WF 7.705/8.007
Posts: 1451 | Location: Portugal | Registered: February 07, 2007
Originally posted by N.Selph: SYSTABLES also gives you all masters on the app path. It has different information than SYSFILES. You might use it depending on what you want to do.
I tried follow up with your information about SYSTABLES but got a message : (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SYSTABLES. Could you please explain it? By the way, when I've got output from SYSFILES table I found in this list master file neither for SYSFILES nor for SYSTABLES.
Take the trailing 'S' off. I do this all the time.
Another technique is to use an operating system command and pipe the output to a file. You can then use a generic master (I call mine LINE80) and use GETTOK and SUBSTR to extract the different pieces and do reports. I also do this all the time. Works great!
We have all our .mas files in one apps folder. What I would like, is to determine all masters that are NOT referenced within any .fex files contained in all folders under ibi\apps. This is to weed out redundant and obsolete master files that are clogging up our masters directory. Alan B's suggestion list all masters in all folders but we don't know if any .fex files references these.
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
There's nothing inherently built in WF to allow you to do that. The only thing you can do is develop a FOCEXEC that reads in each FOCEXEC that you have and form a list of Masters from each line that has a 'TABLE FILE' contained in it and then compare it to the list gnerated by SYSTABLE or SYFILES.
WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003