Software development, photography, jokes, ....

Sites by me

tas-logoTransportation Administration System
snoezelkussen-logo-kleinstSnoezelen Pillows for Dementia
ikzoekeenbegeleider-logoBegeleiders voor gehandicapten
Laat uw hond het jaarlijkse vuurwerk overwinnen
Betuweroute en Kunst
logo 50x50Hey Vos! Je eigen emailadres?
Kunst in huis? Nicole Karrèr maakt echt bijzonder mooie dingen
nettylogo2Kunst in huis? Netty Franssen maakt ook bijzonder mooie dingen
Professionele opvang bij Gastouderbureau
Salarisadministratie en belastingadvies bij
De Zaak Loont
Zutphense Bomenstichting

Hosting Favorites

ANU Internet Services
XelMedia .internet services


Google Translate
jQuery UI
YourHead Stacks API
Favicon Generator. For real.
Check HTTPS problems

Marc's Place


E$LNGU - Update a Language Message file

Start Command

call e$lngu

Call Parameters


Return Parameters


What it does

With this program you can update a Language Message File quick and easy by filling the work file E$LNGUPD with data from, for example, MS-Excel. E$LNGUPD has the following fields:

E$MSGK   Message ID (a7)
E$TEXT Message Text (a132)

When you start E$LNGU, you have to choose the language you are going to update. Choosing a language does not change your library list as E$LNGS does. Next, program E$LNGU1 starts and performs a CHGMSGD for each E$MSGK in the work file.

A smart way to translate and update Language Message Files is the follwoing:

  1. Load the fields E$TEXT, E$TLEN and E$MSGK of E$LNGREF using ODBC into MS-Excel.
  2. Create in MS-Excel a fourth column for the other language you want.
  3. Put the translations in the fourth column.
  4. When you are done, select the columns 3 and 4 and press CTRL-C to copy them to the clipboard.
  5. Start a plain ASCII editor and paste the TAB-delimited text.
  6. Remove the first line (column titles) and replace all TAB-characters with nothing using 'replace all'.
  7. Copy this textfile using FTP or so to the AS/400 into E$LNGUPD.
  8. Start E$LNGU.

Special Options

1 - Select
Use this option to select a language. Only the first record with a 1 is taken when multiple are selected.


Here is an example of the steps described above.

Create the MS-Excel sheet and copy the last two columns:

Start a plain ASCII editor and paste the TAB-delimited text:

Then, with FTP, upload it directly into E$LNGUPD:

Here is the DSPPFM result of E$LNGUPD:

And the last step is to start E$LNGU and choose the language of which the corresponding message file should be updated:

Go to download page
© 1997- Marc Vos (and others)   -   Privacy Statement   -    Contact Me