SQL/MP Version Management Guide

Message File Versions
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
4-3
Retrieving the Version of an Alternate Language
Message File
To use an alternate language message file, you must specify the name of the file by
executing a DEFINE command. The following DEFINE specifies the location and name
of a file containing alternate language messages:
DEFINE =_SQL_MSG_system
In this DEFINE, system is the system name where the SQL/MP software will run; the
system name is specified without a backslash.
You can issue a DEFINE, such as the one shown previously, from TACL. For example,
if you want messages issued in French for your current SQLCI session and the French
translation of the message file is stored in $SYSTEM.FRENCH.SQLMSG, before
starting your SQLCI session, type:
30> ADD DEFINE =_SQL_MSG_SYS2, FILE $SYSTEM.FRENCH.SQLMSG
If you execute this type of command and then run SQLCI or an SQL program on the
specified system (in this case, \SYS2), the alternate language message file is used. Note
that although you can set the DEFINE from SQLCI, the message file used for the
current SQLCI session is not altered.
If you want to resume using the English-language message file or to switch to a different
alternate language message file, exit SQLCI and either delete and re-create a DEFINE,
or alter the DEFINE you initially used to switch to the alternate language message file.
The message file specified in the new or altered DEFINE becomes current when you
start a new SQLCI session.
For example, to return to English-language messages following a request for messages
in French, at the TACL prompt, type:
31> ALTER DEFINE =_SQL_MSG_SYS2, FILE $SYSTEM.SYSTEM.SQLMSG
Retrieving the Version of an Alternate Language Message File
To retrieve the version of an alternate language message file, first issue the statement
DEFINE =_SQL_MSG_system to specify the location of the message file. Then execute
the SQLCI ENV command.
For example, to retrieve the version of the alternate language message file that resides
on \SYS2.$SYSTEM.FRENCH.SQLMSG, type:
33> ADD DEFINE =_SQL_MSG_SYS2, FILE $SYSTEM.FRENCH.SQLMSG
34> SQLCI
>> ENV;
The result is:
---------------------------------------------------------
Current Environment
---------------------------------------------------------
CATALOG\SYS2.$VOL1.SALES
LANGUAGEFRENCH
LOG$VOL1.SUBVOL1.LOGFILE
MESSAGE FILE\SYS2.$SYSTEM.FRENCH.SQLMSG
MESSAGEFILE VRSN315
OUT$TERM1