SQL/MX Report Writer Guide

Using MXCI and the Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
2-4
Invoking Report Writer Mode
Use the ENV command to display the current default settings, as shown:
>> env;
----------------------------------
Current Environment
----------------------------------
CURRENT DIRECTORY /usr/yourdir/bin
HOME DIRECTORY /usr/yourdir
LIST_COUNT 4294967295
LOG FILE
MESSAGEFILE /usr/yourdir/bin/mxcierrors.cat
TERMINAL CHARSET ISO88591
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2003-09-19 09:43 NSK:FIGARO/SUPER.SUPER}
SQL CATALOG CAT
SQL SCHEMA SCH
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>
Invoking Report Writer Mode
To invoke report writer commands from the MXCI command line, set report writer
mode:
>> MODE REPORT;
To exit report writer mode, enter:
>> MODE SQL;
To find out which mode is currently set, enter:
>> MODE DISPLAY;
Note. If you are not in report writer mode, report writer commands entered into the
MXCI command line are treated as syntax errors.