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 NLUSERLANG
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 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 KATAKANA 221 JAPANESE
7 FRENCH 51 ARABIC 231 KOREAN
8 GERMAN
|
Resetting the LANG variable while you are
connected to a DBEnvironment has no effect on the current DBE session.