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] How to handle reports when a table's field is changed?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved] How to handle reports when a table's field is changed?
 Login/Join
 
kncoi
Member
posted
I need to change a field's length in a SQL Server DB table from 4 char to 8. Does anyone know if I need to delete all current reports generated in Development Studio that call this table and recreate them to use the new/revised table or is there a way I can keep the reports and just recompile/refresh to bring in the new table somehow?

Thank you for helping.

This message has been edited. Last edited by: Kathleen Butler,


WebFocus 8.1.03
PMF 8.0.5
Windows Server 2012
Windows 7
html
 
Posts: 20 | Registered: July 29, 2011Report This Post
rfbowley
Platinum Member
posted Hide Post
Your first step, after the database schema is actually changed, is to refresh the synonym so that the .mas file correctly represents the data.

Now it may get a bit tedious, but there is no way to get around it. If a report simply displays the field, then you probably will not have to do anything other than to verify the styling.

If a report uses that field in any COMPUTE or DEFINE, you will have to analyze how it is being used and if it will cause that COMPUTE or DEFINE to fail. The same holds true if the field is saves to an alpha file and a -READ is used to put the value into an amper variable.

Good luck.


Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC

In WebFOCUS since 2001
 
Posts: 132 | Location: Gadsden, Al | Registered: July 22, 2005Report This Post
GamP
Virtuoso
posted Hide Post
And you can use the impact analysis functionality that comes with DevStudio to find out which fexes use that particular field from that particular master file.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
ABT
Master
posted Hide Post
quote:
Originally posted by GamP:
And you can use the impact analysis functionality that comes with DevStudio to find out which fexes use that particular field from that particular master file.


isn't that only available in Resource Analyzer addon?

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
<Emily Duensing>
posted
If you have access to the reporting server console you can use the Impact Analysis utility to find the field that changed in every synonym/procedure that it is used, and see how it is used. The utility is precisely for isolating the impact of a change to a field/table, etc. From the web console, you can right-click an application directory and you will see the option for Impact Analysis.
 
Report This Post
GamP
Virtuoso
posted Hide Post
It's also in DevStudio, regardless of RA/RG.
You'd have to be in the master folder and right click the master to see the Impact Analysis option. The master has to be added to the project though.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
susannah
Expert
posted Hide Post
you're on a windows server...
so with a drive mapped to your server...
use TEXTPAD (http://www.textpad.com)
navigate to the directory(ies) where your fexes are, and
do a FIND IN FILES and search for the string that is your filename
TEXTPAD will tell you what fexes call your file, and the line numbers in those fexes.
in those fexes, change the fieldname(s) in question.
This works if you're writing directly in SQL or with masters using FOCUS code.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
ABT
Master
posted Hide Post
quote:
Originally posted by susannah:
you're on a windows server...
so with a drive mapped to your server...
use TEXTPAD (http://www.textpad.com)
navigate to the directory(ies) where your fexes are, and
do a FIND IN FILES and search for the string that is your filename
TEXTPAD will tell you what fexes call your file, and the line numbers in those fexes.
in those fexes, change the fieldname(s) in question.
This works if you're writing directly in SQL or with masters using FOCUS code.


You've described 25% of my job in the lines above.


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
susannah
Expert
posted Hide Post
Good One
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
kncoi
Member
posted Hide Post
Hi all,

I finally got the issue fixed. The problem was that the revised/corrected joints were not reflected in the reports automatically so they have to be changed manually before correct data can be extracted.

Thanks again. Hope y'all have a great day.

Kim


WebFocus 8.1.03
PMF 8.0.5
Windows Server 2012
Windows 7
html
 
Posts: 20 | Registered: July 29, 2011Report 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] How to handle reports when a table's field is changed?

Copyright © 1996-2020 Information Builders