Neoview Command Interface (NCI) Guide (R2.3)

Examples
This command creates a new connection to the Neoview platform using the login credentials of
the last successful connection:
SQL>reconnect
Connected to DataSource TDM_Default_DataSource
REPEAT Command
The REPEAT command reexecutes a previous command.
Syntax
REPEAT [ text | [-]number ]
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. NCI 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 102).
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• To re-execute the immediately preceding command, enter REPEAT without specifying a
number. If you enter more than one command on a line, the REPEAT command re-executes
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, NCI replaces the SQL terminator in the command with the
current SQL terminator value and executes the command.
Examples
• Display the previously executed commands and re-execute 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
114 NCI Commands