Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] List Procedures by Synonyms

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] List Procedures by Synonyms
 Login/Join
 
Member
posted
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>,
 
Posts: 4 | Location: North America | Registered: June 10, 2014Report This Post
Platinum Member
posted Hide Post
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.
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Member
posted Hide Post
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.


WebFOCUS 7,8
Windows, All Outputs
 
Posts: 4 | Location: North America | Registered: June 10, 2014Report This Post
Guru
posted Hide Post
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.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Master
posted Hide Post
You can get this by using OS scripting commands.

Thanks,
Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Platinum Member
posted Hide Post
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


WF 7.6.11
Output: HTML, PDF, Excel
 
Posts: 123 | Location: UK | Registered: October 09, 2003Report This Post
Virtuoso
posted Hide Post
Not applicable in Relase 8, since the MR fexes are no longer stored in the file system.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Platinum Member
posted Hide Post
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.


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Report This Post
<Kathryn Henning>
posted
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
 
Report This Post
Platinum Member
posted Hide Post
Thanks Kathryn for your response.

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


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Report This Post
<Kathryn Henning>
posted
Hi atturhari,

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

Regards,

Kathryn
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] List Procedures by Synonyms

Copyright © 1996-2020 Information Builders