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

SyntaxDescriptionCommand
See the “LABEL Command”
(page 91).
Marks a point in the command history
that you can jump to by using the
GOTO command.
LABEL
See the “LOCALHOST Command”
(page 92).
Executes client machine commands.LOCALHOST
See the “LOG Command” (page 93).Logs commands and output from NCI
to a log file.
LOG
See the “MODE Command”
(page 95).
Determines the operating mode of the
current session to be either SQL for
database commands, CS for
connectivity service commands, or NS
for the Neoview service commands.
MODE
See the “OBEY Command” (page 97).Runs the SQL statements and NCI
interface commands contained in a
specified script file.
OBEY
See the “PRUN Command” (page 100).Runs script files in parallel.PRUN
See the “QUIT Command” (page 102).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 103).
Reexecutes a command.REPEAT
See the “RESET LASTERROR
Command” (page 104).
Resets the last error code to 0.RESET LASTERROR
See the “RESET PARAM Command”
(page 105).
Clears all parameter values or a
specified parameter value in the
current session.
RESET PARAM
See the “RUN Command” (page 105).Runs the previously executed SQL
statement.
RUN
See the “SAVEHIST Command”
(page 106).
Saves the session history in a
user-specified file.
SAVEHIST
See the “SCHEDULE Command”
(page 107).
Displays or modifies the time during
which automated UPDATE
STATISTICS or MAINTAIN (REORG)
operations are run by the scheduler.
SCHEDULE
See the “SHOW SESSION Command”
(page 138).
Displays attributes of the current NCI
session.
SESSION
See the “SET COLSEP Command”
(page 109).
Sets the column separator and allows
you to control the formatting of the
result displayed for SQL queries.
SET COLSEP
See the “SET CONNECTOPT ROLE
Command” (page 109).
Changes the Neoview role during an
NCI session.
SET CONNECTOPT ROLE
See the“SET FETCHSIZE Command”
(page 110).
Changes the default fetchsize used by
JDBC.
SET FETCHSIZE
See the “SET HISTOPT Command”
(page 111).
Sets the history option and controls
how commands are added to the
history buffer.
SET HISTOPT
See the “SET IDLETIMEOUT
Command” (page 112).
Sets the idle timeout value for the
current session.
SET IDLETIMEOUT
See the “SET LIST_COUNT
Command” (page 113).
Sets the maximum number of rows to
be returned by SELECT statements that
are executed after this command.
SET LIST_COUNT
72 NCI Commands