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     [CLOSED] Company email domain name change

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Company email domain name change
 Login/Join
 
Darryl_uk
Silver Member
posted
Hi,
Company I work for are changing their email domain name. We have lots and lots of reportcaster jobs and distribution lists. Can anyone suggest a way to globally change all of these entries in these lists from @xxxxxx.com to @xxxyyyxxx.com..?

We use WF 7.7.05 and a DB2 database.

Many thanks.

This message has been edited. Last edited by: Darryl_uk,


7.7.05 Windows.
 
Posts: 39 | Location: UK | Registered: July 11, 2012Report This Post
MartinY
Virtuoso
posted Hide Post
If your ReportCaster is configured to use DB2 db, you should be able to find one db that will contain BOTDEST (destfn) and BOTSCHED (distlist, mailhost, mailfrom, notify_brief, notify_reply, ...) tables.
All these table have a reference to an email domain that may need to be changed using a SQL update.

You also have, from Report Caster Console a Global Updates tool that allows you to change some default configuration value.

BUT in all cases, perform a db backup first


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Waz
Expert
posted Hide Post
Ditto with MartinY,

Report caster tables have been in a DB for a while now, and should be easy to do a global change via SQL.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Darryl_uk
Silver Member
posted Hide Post
Thanks folks. I was thinking very much as you suggest - just wondered if there was something easier I had missed.

Many thanks as always for the help and advice.


7.7.05 Windows.
 
Posts: 39 | Location: UK | Registered: July 11, 2012Report 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     [CLOSED] Company email domain name change

Copyright © 1996-2020 Information Builders