ALLBASE/SQL Reference Manual > Chapter 1 Introduction

Native Language Support

	MPE documents
	Complete PDF
	Table of Contents
	Index

	E0300 Edition 9 ♥
	E0399 Edition 8
	E0897 Edition 7

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:

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:

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.

Error Conditions in ALLBASE/SQL

Chapter 2 Using ALLBASE/SQL

Native Language Support

MPE documents