Finding fex's referencing a specific db column

[Darryl Griffiths]

Hi,

It's a while since I used webfocus as a developer (versions 7.6 & 7.7) and we now have version 8.n with development and support outsourced. The folks who look after this system for us seem to be struggling with a wee problem. Don't ask why, but we have changed the precise meaning of a certain column in out database. In practice this means wherever we reference this column in a fex we now need to subtract the value of another column from it to get back to the answer these reports require. Effectivly, if we call this column 'A', we have codethat says 'where A GT 0' and we need to change this code to 'where (A-B) GT 0'.

The problem the team has is finding the fex programs that reference field A. Some will be scheduled reports in Broker, some will be MRE reports. Is it as simple as a windows search on a folder containing the fex code - or are there tools in appstudio that will help

[David Beagan]

Your fex files would typically be in the WebFOCUS repository. You can use Change Management to export the repository content and download the export which is a .zip file. Unzip it then you can use a file search utility such as Agent Ransack to search through the content.

[Manoj Chaurasia]

If the focexecs are stored on the server you could open the synonym in the synonym editor and then from the context menu for the field of interest select Impact Analysis to see a report of every place where the field is used showing name of the procedure, line number, usage and context.

[Ron Moore]

You can use Impact Analysis from App Studio. This will search the repository