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

SyntaxDescriptionCommand
See the “QUIT Command” (page 113).Disconnects from and exits NCI.QUIT
See the “RECONNECT Command”.Creates a new connection to the
Neoview platform using the login
credentials of the last successful
connection.
RECONNECT
See the “REPEAT Command”
(page 114).
Re-executes a command.REPEAT
See the “RESET LASTERROR
Command” (page 115).
Resets the last error code to 0.RESET LASTERROR
See the “RESET PARAM Command”
(page 115).
Clears all parameter values or a
specified parameter value in the
current session.
RESET PARAM
See the “RUN Command” (page 116).Runs the previously executed SQL
statement.
RUN
See the “SAVEHIST Command”
(page 117).
Saves the session history in a
user-specified file.
SAVEHIST
See the “SHOW SESSION Command”
(page 142).
Displays attributes of the current NCI
session.
SESSION
See the “SET COLSEP Command”
(page 117).
Sets the column separator and allows
you to control the formatting of the
result displayed for SQL queries.
SET COLSEP
See the “SET HISTOPT Command”
(page 118).
Sets the history option and controls
how commands are added to the
history buffer.
SET HISTOPT
See the “SET IDLETIMEOUT
Command” (page 119).
Sets the idle timeout value for the
current session.
SET IDLETIMEOUT
See the “SET LIST_COUNT
Command” (page 120).
Sets the maximum number of rows to
be returned by SELECT statements that
are executed after this command.
SET LIST_COUNT
See the“SET MARKUP Command”
(page 121).
Sets the markup format and controls
how results are displayed by NCI.
SET MARKUP
See the “SET PARAM Command”
(page 124).
Sets a parameter value in the current
session.
SET PARAM
See the “SET PROMPT Command”
(page 125).
Sets the prompt of the current session
to a specified string or to a session
variable.
SET PROMPT
See the “SET SQLPROMPT
Command” (page 127).
Sets the SQL prompt of the current
session to a specified string. The default
is SQL.
SET SQLPROMPT
See the “SET SQLTERMINATOR
Command” (page 128).
Sets the SQL statement terminator of
the current session to a specified string.
The default is a semicolon (;).
SET SQLTERMINATOR
See the “SET TIME Command”
(page 130).
Causes the local time of the client
workstation to be displayed as part of
the interface prompt.
SET TIME
See the“SET TIMING Command”
(page 131).
Causes the elapsed time to be displayed
after each SQL statement executes.
SET TIMING
See the“SHOW ACCESS Command”
(page 131).
Displays the current status of the
super.services access to memory dump
files.
SHOW
See the “SHOW COLSEP Command”.Displays the value of the column
separator for the current NCI session.
SHOW COLSEP
90 NCI Commands