Hi All,

I want to build a report in Webfocus which can list Procedures linked with a particular Synonym.

So far I've been able to list synonyms, table name, column names and Application directory.
Here is the code for that:

APP LIST HOLD
-RUN
TABLE FILE FOCAPPL
PRINT APPNAME
ON TABLE SAVE AS TMP_APP
END
-RUN
-SET &APP_Count = &LINES ;
-REPEAT APP_LOOP &APP_Count TIMES
-READ TMP_APP NOCLOSE &APP_Name.A64.
APP PATH &APP_Name
-RUN
TABLE FILE SYSCOLUM
PRINT COMPUTE APP_DIR/A64 = '&APP_Name' ;
TBNAME
NAME
END
-APP_LOOP


Is there any System Table that contains information about all Procedures and Synonyms.

Thanks,
Inder

This message has been edited. Last edited by: <Kathryn Henning>,

If you want to list all procedures used by a particular synonym, you can use Impact Analysis.
It can be run out of the Reporting Server Web Console,Data Management Console, or Developer Studio.

Hi Efrem,

Thanks for your response. But Impact Analysis can't list procedures built in the Managed Reporting Section. I want to create an intreactive report where I can enter Synonym name or Procedure name and get all the related information.

I build one such report(above code) with gives me Synonym table name, Column name and application directory, but not procedure information.

Am not sure of any solution inside WebFOCUS for this.. Hopefully Some FILE handling solution is something that you have to go for.

Say for example - some Java application(code) that will take the synonym name as input parameter and can read through all FEX files in a directory(sub-directories), do for a pattern matching of the Synonym name provided, return the FEX file name if pattern matching found.

You can get this by using OS scripting commands.

Thanks,
Ram

Have a look at this old post. This uses WebFOCUS to write the contents of all the fexes in a chosen folder to a focus db where the results can be parsed for reporting.

It might give you some ideas.

http://forums.informationbuild...051092692#7051092692

Not applicable in Relase 8, since the MR fexes are no longer stored in the file system.

quote:

Originally posted by j.gross:
Not applicable in Relase 8, since the MR fexes are no longer stored in the file system.

Found the following thread, which might provide the solution.
http://forums.informationbuild...051092692#7051092692

However, looks like the above approach would not work in WF 8.

How to go about automating this in WF 8? Can anyone shed some light on this.

Hi All,

Starting with WebFOCUS release 8.0.07, a New Feature was implemented that allows you to extract the contents of the Repository in text format which can then be searched. For additional information, please see:

How to extract the WebFOCUS 8 CM Repository Content in Text

Regards,

Kathryn

Thanks Kathryn for your response.

Can you clarify if the "Repository contents" in WF 8 would also contain InfoAssist reports created by users?

Hi atturhari,

Yes, the Repository contents include WebFOCUS 8 InfoAssist metadata and reports created by users.

Regards,

Kathryn