4.5 Multilingual Database Design Considerations

Some important design considerations apply to developing truly multilingual applications. Consider the following simple sequence of screen panels representing a product inquiry:

^{Specify Product Number}

^{Key in Product Number and press Enter.}

^{Product Number . . . . . . . 64786}

^{Product Details}
^{Product Number . . . . . :  64786}
^{Description  . . . . . . . . . :  1 kg plastic bag of cane sugar}
^{Short Description  . . . :  SUGAR 1KG}
^{Price  . . . . . . . . . . . . . . . :  2.45}
^{Stock on Hand  . . . . . . :  7685}

Initially the RDML program could be coded like this:

     GROUP_BY NAME(#PANEL001) FIELDS(#PRODNO #PRODES #PROSDES #PRICE #STOCK)
     BEGIN_LOOP
     REQUEST FIELD((#PBINST01 *OUTPUT *NOID) #PRODNO)
     FETCH FIELDS(#PANEL001) FROM_FILE(PRODMST) WITH_KEY(#PRODNO)
             IF_STATUS IS_NOT(*OK)
             MESSAGE MSGTXT(*MTXT12347)
             ELSE
             DISPLAY FIELDS(#PANEL001)
             ENDIF
     END_LOOP

By setting up the correct multilingual attributes for this program you can instantly achieve the following variations in this program. Refer to Specifying a Field's Multilingual Attributes for details.

Execute the application in French

^{Specification du Numero de Produit}

^{Tapez le Numero de Produit puis faites Enter}

^{Numero de Produit . . . . . 64786}

^{Details du Produit}

^{Numero de Produit . . . : 64786}^{Description . . . . . . : 1 kg plastic bag of cane sugar}^{Description Abregee . . : SUGAR 1KG}^{Prix . . . . . . . . . . : 2.45}^{Stock Disponible . . . . : 7685}

Execute the application in German

^{Produkt Nummer Angeben}

^{Geben Sie die Produkt Nummer ein und drucken Sie Eingabe}

^{Produkt Nummer . . . . . . . . . . . . . 64786}

^{Produkt Detail}

^{Produkt Nummer . . . . . . : 64786}^{Seschreibung . . . . . . . . . . : 1 kg plastic bag of cane sugar}^{Kurzbeschreibung . . . . . . : SUGAR 1KG}^{Preis . . . . . . . . . . . . . . . . . : 2.45}^{Verfugbare Menge . . . . . . : 7685}

Notice what's wrong?

The product description and short description shown are still in English.

This simple example illustrates a very important point.

LANSA can get all the details it knows about out on the screen in the correct language, but because this is intended to be a completely multilingual program, it should have stored the product details in two separate files:

One for the non-language dependent product details (like price and stock on hand);
The other for the language dependent product details (like the long and short descriptions).

If the program was coded like this (making use of the system variable *LANGUAGE to determine the language):

     GROUP_BY NAME(#PANEL001) FIELDS(#PRODNO #PRODES #PROSDES #PRICE #STOCK)
 
     BEGIN_LOOP
     REQUEST FIELD((#PBINST01 *OUTPUT *NOID) #PRODNO)
     FETCH FIELDS(#PANEL001) FROM_FILE(PRODMST) WITH_KEY(#PRODNO)
     FETCH FIELDS(#PANEL001) FROM_FILE(PRODLNG) WITH_KEY(*LANGUAGE #PRODNO)
              IF_STATUS IS_NOT(*OK)
              MESSAGE MSGTXT(*MTXT12347)
              ELSE
              DISPLAY FIELDS(#PANEL001)
              ENDIF
     END_LOOP

The result would be a true multilingual system where side by side users could be running the same program in completely different languages.

Execute the application in French

^{Specification du Numero de Produit}

^{Tapez le Numero de Produit puis faites Enter}

^{Numero de Produit . . . . . 64786}

^{Details du Produit}

^{Numero de Produit . . . : 64786}^{Description . . . . . . : 1 kg sac plastique de sucre}^{Description Abregee . . : SUCRE 1KG}^{Prix . . . . . . . . . . : 2.45}^{Stock Disponible . . . . : 7685}

Execute the application in German

^{Produkt Nummer Angeben}

^{Geben Sie die Produkt Nummer ein und drucken Sie Eingabe}

^{Produkt Nummer . . . . . . . 64786}

^{Produkt Detail}

^{Produkt Nummer . . . . . :  64786}
^{Seschreibung . . . . . . . . :  1 kg Plastiksack mit Rohzucker}
^{Kurzbeschreibung . . . . :  ZUCKER 1KG}
^{Preis  . . . . . . . . . . . . . . . . :  2.45}
^{Verfugbare Menge . . . . :  7685}

Content

Space Tools

Execute the application in French

Execute the application in German

Execute the application in French

Execute the application in German