Filter
Top Products
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
-------------------------------------------------------------
DEPT EMPLOYEE JOB PROJECT
SQL>
RESET PARAM Command
The RESET PARAM command clears all parameter values or a specified parameter value in the
current session.
RESET PARAM Command 99