SQL/MP Report Writer Guide

Using SQLCI and the Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
2-18
Defining Reports in Command Files
•
You can save other commands such as the VOLUME command. For example,
the following command saves the command that begins with the letters
VOLUME $I from the history buffer:
SAVE COMMAND VOLUME $I TO ORDFILE;
You can use the HISTORY command to display commands you might want to
save. The order in which you save the commands can be significant; for example,
you should save the VOLUME command before you save a SELECT command
that depends on the correct default volume being set.
5. You can produce the report again by entering the OBEY command at the
standard prompt:
>> OBEY ORDFILE ;
The select-in-progress prompt appears after you execute the file. You can use the
LIST command to list all or part of your report:
S> LIST ALL;
To print your report, use the OUT_REPORT command before you enter the OBEY
command to specify a printer as the output device for reports as shown in this
example:
>> OUT_REPORT $S1.#PRINT;
>> OBEY ORDFILE;
When you are defining a report interactively, remember:
•
You can change part of the report by entering a single command again without
entering all of the commands.
•
If you enter a BREAK, SUBTOTAL, or TOTAL command to the report format after
listing some rows, the report writer returns you to the beginning of the SELECT
output, as if you had entered the LIST FIRST command.
If the command file does not include a LIST command, you can make changes to the
report definition at the select-in-progress prompt (S>) as shown in Figure 2-10
. Thus,
you can revise commands if necessary and save the report definition again by using
the CLEAR option of the SAVE command to erase the previous report definition.