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

On this website, Google Analytics is used to track visitor statistics. These are anonymised data about the number of visitors, which pages they visit on this site, from which regions they visit, which web browsers they use, etc.. You will also see non-personalised ads via Google AdSense. Cookies from Paddle or Paypal are placed when you click on a 'Buy now!' or 'Donate!' button, and possible cookies from Disqus when you use that system to comment on one or more blogposts.
Privacy Statement