HP 3000 Manuals

ALLBASE/SQL FORTRAN Application Programming Guide

Native Language Support 

ALLBASE/SQL lets you manipulate databases in a wide variety of native
languages in addition to the default language, known as NATIVE-3000.  You
can use either 8-bit or 16-bit character data, as appropriate for the
language you select.  In addition, you can always include ASCII data in
any database, since ASCII is a subset of each supported character set.
The collating sequence for sorting and comparisons is that of the native
language selected.

You can use native language characters in a wide variety of places,
including:

   *   Character literals.
   *   Host variables for CHAR or VARCHAR data (but not variable names).
   *   ALLBASE/SQL object names.
   *   WHERE and VALUES clauses.

If your system has the proper message files installed, ALLBASE/SQL
displays prompts, messages and banners in the language you select, and it
displays dates and time according to local customs.  In addition, ISQL
accepts responses to its prompts in the native language selected.
However, regardless of the native language used, the syntax of ISQL and
SQL commands--including punctuation--remains in ASCII.

Note that MPE XL does not support native language file names nor
DBEnvironment names.

In order to use a native language other than the default, you must do the
following:

   1.  Make sure your I/O devices support the character set you wish to
       use.

   2.  Set the MPE job control word NLUSERLANG to the number (LangNum) of
       the native language you wish to use.  Use the following MPE XL
       command:

            SETJCW NLUSERLANG = LangNum 

       This language then becomes the current language.  (If NLUSERLANG
       is not set, the current language is NATIVE-3000.)

   3.  Use the LANG = LanguageName option of the START DBE NEW command to
       specify the language when you create a DBEnvironment.

Run the MPE XL utility program NLUTIL.PUB.SYS to determine which native
languages are supported on your system.  Here is a list of some supported
languages, preceded by the LangNum for each:

       0 NATIVE-3000         9 ITALIAN            52 ARABICW
       1 AMERICAN           10 NORWEGIAN          61 GREEK
       2 C-FRENCH           11 PORTUGUESE         71 HEBREW
       3 DANISH             12 SPANISH            81 TURKISH
       4 DUTCH              13 SWEDISH           201 CHINESE-S
       5 ENGLISH            14 ICELANDIC         211 CHINESE-T
       6 FINNISH            41 KATAKANAC         221 JAPANESE
       7 FRENCH             51 ARABIC            231 KOREAN
       8 GERMAN

Any one user would not be using all of these languages at one time, of
course.  The languages you want need to be initialized on the MPE XL
system and the MPE XL system rebooted.  Once that is done, the
NLUTIL.PUB.SYS program might display the following, assuming that the
languages listed are those that have been initialized on MPE XL:

     Lang   Lang                    Char         Char
       ID   Name                      ID         Name
     ----   ----                    ----         ----
        0   NATIVE-3000                0         USASCII
        1   AMERICAN                   1         ROMAN8
        5   ENGLISH                    1         ROMAN8
        7   FRENCH                     1         ROMAN8
        8   GERMAN                     1         ROMAN8

Note that ENGLISH is British English and AMERICAN is American English.

Resetting NLUSERLANG while you are connected to a DBEnvironment has no
effect on the current DBE session.

MPE/iX 5.0 Documentation