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