SQL/MX Report Writer Guide

Using MXCI and the Report Writer

HP NonStop SQL/MX Report Writer Guide—527194-002

2-15

Defining Reports in Command Files

If you are listing rows retrieved by a SELECT command and decide to change the

command, use a CANCEL command to return to the MXCI prompt. Then, enter the FC

or ! command.

Defining Reports in Command Files

There are two ways to define a report in a command file:

•

You can create the report commands in a command file using a text editor.

•

You can log only the commands to a log file and then use the log file as a

command file.

Figure 2-6. Repeating Stored Commands

Note. You must use the semicolon terminator for FC and ! commands.

>> SELECT PARTNUM, QTY_AVAILABLE

.. I, PRICE

Press RETURN.

Insert change and press RETURN.

>> FC SELECT

>> SELECT PARTNUM, QTY_AVAILABLE, PRICE

Press RETURN.

+> FROM PARTS;

Request History.

MXCI displays

most recent

commands.

Reexecute command 3

MXCI displays and executes

command

Example 2

>> HISTORY 7

3 > SELECT PARTNUM, QTY_ AVAILABLE FROM PARTS;

4 > LIST ALL;

5 > FC SELECT

6 > SELECT PARTNUM, QTY_ AVAILABLE, PRICE FROM PARTS;

7 > LIST NEXT 3 ;

8 > CANCEL;

9 > HISTORY 7;

>> ! 3

>> SELECT PARTNUM, QTY_ AVAILABLE

+> FROM PARTS;

VST0209.vsd

Example 1