Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
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?
Go
New
Search
Notify
Tools
Reply
  
[Solved] How to handle reports when a table's field is changed?
 Login/Join
 
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, 2011Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
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, 2010Reply With QuoteReport 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.
 
Reply With QuoteReport This Post
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 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
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, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Good One
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
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, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.