SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

text
specifies the text of the most recently run command. The command must have been run beginning
with text, but text need be only as many characters as necessary to identify the command.
RMXCI ignores leading blanks.
[-]number
is an integer that identifies 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.
The history command displays the commands or statements in the history buffer. See the
“HISTORY command” (page 91).
Considerations
• You must enter the command in one line.
• To rerun the previous command, enter repeat command without specifying a number. If you
enter more than one command on a line, the repeat command reruns only the last command
on the line.
• When a command is selected for repeat, and the SQL terminator value has changed since
the execution of that command, RMXCI replaces the SQL terminator in the command with the
current SQL terminator value and runs the command.
Examples
• The following example displays the previously run commands and reruns the second to the
last command:
SQL>history
1> set idletimeout 0
2> log on
3> set schema persnl;
4> select * from employee;
5> show views
6> select * from dept;
7> show views
8> select * from emplist;
SQL>
SQL>repeat -2
show views
VIEW NAMES
-------------------------------------------------------------
EMPLIST MGRLIST
SQL>
• The following example reruns the seventh command in the history buffer:
SQL>repeat 7
show views
VIEW NAMES
-------------------------------------------------------------
EMPLIST MGRLIST
SQL>
• The following example reruns the show views command:
SQL>repeat show
show views
VIEW NAMES
REPEAT command 103