SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
E-4
Example—ENV

You can use the CATALOG, LOG, OUT_REPORT, SYSTEM, and VOLUME
commands to change current default values for the SQLCI session. You can
change the OUT file with the OUT command (or with the OUT run option when you
start an SQLCI session).
You can specify a different SQL message file for an SQLCI session by setting the
=_SQL_MSG_node DEFINE before you start the SQLCI session. Changing the
DEFINE after you start SQLCI, however, does not change the message file. (You
cannot change the message file version and language directly because they
depend upon the message file in use.)
Example—ENV
This example shows the output of an ENV command that is entered at a select-in-
progress prompt.
S> ENV;
--------------------------------------------------
Current Environment
--------------------------------------------------
CATALOG \SYS1.$VOL1.SALES
LANGUAGE AMERICAN ENGLISH
LOG $VOL1.SUBVOL1.LOGFILE
MESSAGEFILE \SYS.$SYSTEM.SYSTEM.SQLMSG
MESSAGEFILE VRSN 315
OUT \SYS1.$TERM1
OUT_REPORT $S.#PRINTER
SYSTEM \SYS1
TRANSACTION ID \SYS1.0.474330
VOLUME $VOL1.PERSNL
WORK IN PROGRESS
S>
ERROR Command
ERROR is an SQLCI command that displays the error text associated with an error
number and, optionally, the cause and effect of the error and suggestions for recovery.
ERROR [ [ type ] number [ , { DETAIL } ] ] ;
[ [ { BRIEF } ] ]
type is:
{ AUD }
{ DP }
{ FS }
{ OS }
{ SIO }
{ SORT }
{ SQL }