Neoview Script Guide (R2.2)

text
specifies the text of the most recently executed command. The command must have been
executed beginning with text, but text need be only as many characters as necessary to
identify the command. Neoview Script 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 94).
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
• To reexecute the immediately preceding command, enter REPEAT without specifying a
number. If you enter more than one command on a line, the REPEAT command reexecutes
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, Neoview script replaces the SQL terminator in the command
with the current SQL terminator value and executes the command.
Examples
• Display the previously executed commands and reexecute 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 tables
6> select * from dept;
7> show views
8> select * from emplist;
SQL>
SQL>repeat -2
show views
VIEW NAMES
-------------------------------------------------------------
EMPLIST MGRLIST
SQL>
• Reexecute the fifth command in the history buffer:
SQL>repeat 5
show tables
TABLE NAMES
-------------------------------------------------------------
DEPT EMPLOYEE JOB PROJECT
SQL>
• Reexecute the SHOW TABLES command:
SQL>repeat show
show tables
TABLE NAMES
-------------------------------------------------------------
104 Neoview Script Interface Commands