SQL/MP Report Writer Guide

Using SQLCI and the Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
2-14
Executing a Command Repeatedly
Repeating Stored Commands
You can use the FC and ! commands to repeat a command you have entered during
your SQLCI session. The exclamation point command repeats a command but does
not allow you to modify it. The FC command allows you to edit the command before
reexecuting it.
To execute a previous command that begins with the text SELECT P, enter the
following:
>> ! SELECT P
SQLCI displays and executes the command:
>> SELECT PARTNUM, QTY_AVAILABLE
+> FROM SALES.PARTS;
Figure 2-9 shows two examples of repeating commands. The first example shows how
to revise a command and reexecute it by using the FC command. Enter sufficient text
to distinguish the command from other previously entered commands.
The second example in Figure 2-9 shows how to display the last seven commands and
reexecute command number three by using the HISTORY command. You can use the
HISTORY command to display up to 25 of the most recently executed commands.