ALLBASE/SQL lets you manipulate databases in a number 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 the following
places, including:
Host variables for CHAR or VARCHAR data (but not 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 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 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
|
Resetting NLUSERLANG while you are connected to a DBEnvironment
has no effect on the current DBE session.