Technical Blog Post
Abstract
HOW TO: Remove or Uninstall additional language in Maximo
Body
Ever wonder how to remove a secondary or an additional language in Maximo? Today's your lucky day as I will walk you through on how you can do it in this blog entry.
First of all, there is no functionality of TDToolkit that will remove a secondary language. Therefore we will be doing this activity in the back-end, direct to your database.
We can start by viewing your available languages in your database. To view all your installed additional languages, run the following query against your database:
select languagename, maxlangcode from language where enabled = 1;
*This will list ALL languages including the base language.
e.g.:
If you are not sure what your base language is, run the following query:
select varvalue from maxvars where varname = 'BASELANGUAGE';
e.g.:
Once you know the language code for the language you want to remove, run the following SQL command against your database.
update language set enabled = 0 where maxlangcode = 'DE';
*Replace the DE with the code of the language you want to remove.
*This will disable the language but it will not remove the actual translation.
If you want to remove the actual translation in the database, continue on following the instructions below:
1) Run the following command and replace the DE with your language code.
select 'delete from ' || langtablename || ' where langcode = ''DE'';' from maxtable where langtablename is not null;
2) Run the output from the SQL in step 1 separately, SQLServer might need some tweaking to work if the table names are case sensitive.
3) Finally remove the language from the table used to keep track of versions:
delete from tdtversion where language = 'DE';
*This will remove the actual translation from the database.
IMPORTANT NOTE: Keep in mind that the MXServer needs to be restarted after either the disabling or the removal of an additional language. Make sure you do not disable the Base Language.
UID
ibm11130313