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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
I work on my predecessor's report that getting data from a HOLD file. The HOLD file needs to be updated before running the report based on the result (old data shown up). I could not find any documentation left for me. Would it be possible to trace back which fex generate that HOLD file? Otherwise, I might have to start that report from scratch.
Thank you.This message has been edited. Last edited by: FP Mod Chuck,
App and Dev Studio have a feature on master files to scan where that master is used named "Impact Analysis". That does the reverse of what you want.
Something feature to scan where a master is generated (if it is a HOLD-file), would be useful.
It happens frequently enough that we're looking in a procedure that someone else created, or one of our own that was created a while ago, that we're left searching.
We usually grep the *.fex files in the file system.
If you're stuck with the repository you can probably use a select with a like expression - if the field type used to store the fex in the DBMS in question permits that. BLOBs are often not very query-friendly, for example.
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 :
From within App Studio (and Developer Studio) you can copy all the files (fex, mas, acx ...) to a Windows directory. I do this frequently to keep the previous versions before I change focexecs. You can then use a search tool to look for the focexecs(s) that create your hold file. I have had good luck with Agent Ransack.
WebFOCUS 8.2.03 - Production WebFOCUS 8.2.04 - Sand Box Windows 2012 R2 Server HTML, PDF, Excel In FOCUS since 1980
Posts: 115 | Location: Seattle, WA | Registered: April 07, 2015
Chuck - I don't see the fex file that creating this HOLD file. I only see the fex that using this HOLD file to generate the report I want in the Content folder. The HOLD file is in EDASERVE\Application folder.
Dave - I checked that HOLD filename, but unfortunately no other filename being similar to that HOLD file.
Wep5622 - thanks for that tip. After using Impact analysis, all I see are fex files using that HOLD file, not the one creating it.
Michael - thanks for the advice. I will do this from now on. Sometimes I feel that files are disappeared for no reason. Maybe too many hands in the pot.
I will wait until my IT staff takes a look on this and his backup. If file is not found, I have no choice to recreate that fex file and mimic that output for that HOLD file.