ALLBASE/SQL Reference Manual (36216-90216)

58 Chapter1
Introduction
Native Language Support
You can use native language characters in a wide variety of places, including these:
• Character literals
• Values stored in host variables for CHAR or VARCHAR data (but not as variable names)
• ALLBASE/SQL object 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:
1. Make sure your I/O devices support the character set you use.
2. 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.)
3. 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:
Resetting the LANG variable while you are connected to a DBEnvironment has no effect on
the current DBE session.
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