SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-1
Z
! Command
! (exclamation point) is an SQLCI command that re-executes a statement or command
without modifying a previous statement or command in the history buffer or a current
report formatting command. For more information, see HISTORY Command on
page H-5.
text
specifies the most recent version of a command in the history buffer or a stored
report formatting command. The command must begin with text, but text need
only be as many characters as necessary to identify the command.
number
is an integer that specifies a command in the history buffer.
If number is negative, it indicates the position of the command in the history buffer
relative to the current command; if number is positive, it is the ordinal number of a
command in the history buffer.
To re-execute the previous command, you can enter an exclamation point (!)
without specifying text or a number. If you enter more than one SQLCI command
on a line, the exclamation point re-executes only the last command on the line.
Examples—!

To reexecute the last SELECT command, enter:
>> ! SELECT

To reexecute the second to the last command entered, enter:
>> !-2
! [ text ] [ ; ]
[ [-]number ]