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, because 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 these:
Values stored in host variables for CHAR or VARCHAR data (but not as variable names)
If your system has the proper message files installed, ALLBASE/SQL
displays prompts, messages and banners in the language you select;
and it displays system 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 statements--including punctuation--remains in ASCII.
Note that MPE XL does not support either native language file names
or DBEnvironment names.
In order to use a native language other than the default,
you must follow the steps below:
Make sure
your I/O devices support the character set you use.
Set the MPE job control word NLUSERANG to the number(LangNum) of the native language you 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.)
Use the LANG = LanguageName option of the START DBE NEW statement to specify the language of a DBEnvironment
when you create it. Run the MPE XL utility program NLUTIL.PUB.SYS to determine which native languages are supported on
your system Here is a list of supported languages, preceded by the
LangNum for each:
| 0 | NATIVE-3000 | 7 | FRENCH | 13 | SWEDISH | 71 | HEBREW |
| 1 | AMERICAN | 8 | GERMAN | 14 | ICELANDIC | 81 | TURKISH |
| 2 | C-FRENCH | 9 | ITALIAN | 41 | KATAKANA | 201 | CHINESE-S |
| 3 | DANISH | 10 | NORWEGIAN | 51 | ARABIC | 211 | CHINESE-T |
| 4 | DUTCH | 11 | PORTUGEUSE | 52 | ARABICW | 221 | JAPANESE |
| 5 | ENGLISH | 12 | SPANISH | 61 | GREEK | 231 | KOREAN |
| 6 | FINNISH | | | | | | |
Resetting the LANG variable while you are connected to a DBEnvironment
has no effect on the current DBE session.
Printable version
