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:
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:
Make sure your I/O devices support the character set you wish
to use.
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.)
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.