SQL/MP Version Management Guide

Compaq NonStop™ SQL/MP Version Management Guide—429833-001

4-1

Message File Versions

Errors, warnings, and help text are stored as messages in NonStop SQL/MP message

files. Messages in message files are returned through the SQL/MP conversational

interface (SQLCI) and through the SQL programmatic interface.

Messages returned by SQL/MP can originate from various SQL/MP software

components, including the SQL file system, the SQL compiler, and the FastSort

program.

For more information about SQL/MP messages, including descriptions of particular

messages, see the NonStop SQL/MP Messages Manual.

SQL/MP Message File Versions and Software

Versions

The content of the SQL/MP message file changes with each release, as messages are

added or modified. Likewise, the version number of the message file changes as the

version number of the SQL/MP software changes.

The version of an SQL message file does not have to be the same as the version of the

SQL/MP software that accesses the message file. This flexibility allows message files to

be updated between versions of the software.

If an older version of a message file is used with a newer version of SQL/MP software,

the SQL/MP software might try to access a particular message that does not exist in the

older message file. In this case, SQL/MP returns a warning that states that the message

is missing.

You can avoid such warnings by verifying that the version of the message file you are

using has the same (or newer) version number as the SQL/MP software being used, as

described here.

Retrieving the Message File Version

The SQLCI environment variable MESSAGEFILE VRSN contains the version of the

message file being used for the current SQLCI session. You can display the contents of

the MESSAGEFILE VRSN variable, along with a listing of other environment-related

information, by executing the SQLCI ENV command:

>> ENV;

The SQLCI ENV command results in this output:

-------------------------------------------------------

Current Environment

-------------------------------------------------------

CATALOG\SYS2.$VOL1.SALES

LANGUAGEAMERICAN ENGLISH

LOG$VOL1.SUBVOL1.LOGFILE

MESSAGE FILE\SYS2.$SYSTEM.SYSTEM.SQLMSG