How Related Language Tables Store Translations
Base tables store language-sensitive descriptions in the database's base language. Related language tables store translations of these descriptions in non-base languages. For each row in the base table, there can be zero rows or one row in the related language table for each non-base language.
For example, the following table shows a row of data from the PSMSGCATDEFN table.
| MESSAGE_SET_NBR | MESSAGE_NBR | MESSAGE_TEXT | MSG_SEVERITY | DESCRLONG |
|---|---|---|---|---|
|
1 |
1 |
Distributed Object Manager: Help Name=%1 Language=%2 |
M |
A Help Text object is being retrieved from the database. This message is for your information only. It is not an error or a warning. |
The following table shows child rows of data from the PSMSGCATLANG table. For each LANGUAGE_CD, there is a row with appropriate translations of the language-sensitive fields, DESCRLONG and MESSAGE_TEXT, from the parent row.
| MESSAGE_SET_NBR | MESSAGE_NBR | LANGUAGE_CD | MESSAGE_TEXT | DESCRLONG |
|---|---|---|---|---|
|
1 |
1 |
ESP |
Gestor de objetos distribuidos: Nombre de ayuda=%1 Idioma=%2 |
Se está recuperando un objeto texto de ayuda de la base de datos. Este mensaje sólo es informativo. No es un error ni un aviso. |
|
1 |
1 |
FRA |
Gestionnaire d'objets répartis: Aide=%1 Langue=%2 |
Un objet de type Aide en ligne est extrait de la base de données. Ce message est affiché seulement à titre d'information. Ce n'est ni un message d'erreur, ni un message d'avertissement. |