IBM RegTech Ideas Portal



Our team welcomes any feedback and suggestions you have for improving our offerings. This forum allows us to connect your product improvement ideas with IBM product and engineering teams.


For product documentation, see Knowledge Center.
Create and View Support Cases and Use the Discussion Forum here


Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases


The shorter URL for this site is:

IBMers, please visit the WFSS Internal Ideas portal


note: The IBM ICM IDEAS Portal is no longer available at this location. If you have reached this page, please look for a new link in the Varicent Administrator. Direct links are found under the "?" in the upper right corner.
A period of transition is likely to impact this service, while ICM becomes Varicent. Please contact Varicent support if you have additional challenges or concerns.

Changing the base currency with DB2 database

When OpenPages is installed with a default USD base currency or any other base currency, there should be a way to change that currency later on instead of reinstalling the environment.
I raised a PMR 85146,024,677 and a SQL script was provided to reset base currency but it gave an error. The following were the comments from IBM Srini on PMR.
"It appears like we don't have a working script for DB2 database. The script that I sent you has got some issues. Apologies for sending that script to you. We have tried the script on Oracle database and it has worked couple of times but may be you are the first customer to try the script on DB2 database.
The feedback is that we currently don't have a supported method to change the base currency. The script that was sent was a custom script that was developed for a customer so it appears like it is not a generic one and is also not certified by the Product Management team.
Unfortunately, we don't have a certified and supported script to change the base currency. I suggest you to raise an enhancement request for this".
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Mar 29 2019
  • Capability Already Exists
Component Administration
Priority Urgent - Blocker
  • Attach files
  • Admin
    JOHN Lundgren commented
    7 May 05:25pm

    Thank you again for submitting this Idea!

    Our Customer Support Team can assist with any Client who wishes to chnage their Base Currency.