SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-18
=_SQL_MSG_node DEFINE
=_SQL_MSG_node DEFINE
=_SQL_MSG_node is a system DEFINE that directs SQL to use an alternate message
file. It allows you to specify message files that provide SQL messages in languages
other than English.
node
is the name of the node running the SQL software that is to use the alternate
message file. Specify the node name without the leading backslash (\).
msg-file
is the name of the alternate message file.
Considerations—=_SQL_MSG_node

The SQL message file is a key-sequenced file that contains the text of most of the
messages displayed by SQL. SQL retrieves messages from the file as needed.
The standard SQL message file, provided with NonStop SQL/MP, is placed in
$SYSTEM.SYSTEM.SQLMSG when NonStop SQL/MP is installed on a node. All
the messages in the file are in English.
The =_SQL_MSG_node DEFINE allows you to designate a different file as the
SQL message file for SQL if an appropriate file is available on your network. (HP
does not provide alternate SQL message files as a standard part of NonStop
SQL/MP. You should check at your site to determine what alternate message files,
if any, are available to you.)
When SQL must open the SQL message file, SQL determines whether a
=_SQL_MSG_node DEFINE is in effect for the node for the process running SQL.
If the DEFINE is in effect, SQL uses the message file specified in the DEFINE. If
there is no =_SQL_MSG_node DEFINE in effect, or if the file specified in the
DEFINE does not exist, is invalid, or is incompatible with the SQL software that
attempted to open it, then SQL opens the message file in
$SYSTEM.SYSTEM.SQLMSG.

To use an alternate message file from SQLCI, you must specify an
=_SQL_MSG_node DEFINE in TACL before you start the SQLCI session. SQL
opens the message file at the beginning of an SQLCI session and leaves the file
open throughout the session. As a result, changing DEFINEs during the session
has no effect on the SQL message file used for that session.
If you regularly use an alternate message file from SQLCI, you might want to place
an =_SQL_MSG_node DEFINE in your TACLCSTM file so that it is in effect
whenever you log on. For information about TACLCSTM, see the TACL Reference
Manual.
ADD DEFINE =_SQL_MSG_node, CLASS MAP, FILE msg-file