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

SyntaxDescriptionCommand
See the “SHOW HISTOPT Command”
(page 132).
Displays the value that has been set for
the history option of the current setting.
SHOW HISTOPT
See the “SHOW IDLETIMEOUT
Command” (page 133).
Displays the idle timeout value of the
current session.
SHOW IDLETIMEOUT
See the “SHOW LASTERROR
Command” (page 133).
Displays the last error of the statement
that was executed.
SHOW LASTERROR
See the “SHOW LIST_COUNT
Command” (page 134).
Displays the maximum number of rows
to be returned by SELECT statements
in the current session.
SHOW LIST_COUNT
See the “SHOW MARKUP
Command” (page 134).
Displays the value that has been set for
the markup option for the current NCI
session.
SHOW MARKUP
See the “SHOW MODE Command”
(page 135).
Displays the operating mode of the
current session.
SHOW MODE
See the “SHOW MVGROUPS
Command” (page 135).
Displays all or a set of the materialized
view groups in the current schema of
the NCI session.
SHOW MVGROUPS
See the “SHOW MVS Command”
(page 136).
Displays all or a set of the materialized
views in the current schema of the NCI
session.
SHOW MVS
See the “SHOW PARAM Command”
(page 138).
Displays the parameters that are set in
the current session.
SHOW PARAM
See the “SHOW PREPARED
Command” (page 138).
Displays the prepared statements in
the current NCI session.
SHOW PREPARED
See the “SHOW PROCEDURES
Command” (page 139).
Displays the procedures (Stored
Procedures in Java) in the current
schema of the NCI session.
SHOW PROCEDURES
See the “SHOW SCHEMA Command”
(page 140).
Displays the current schema of the NCI
session.
SHOW SCHEMA
See the “SHOW SCHEMAS
Command” (page 141).
Displays all or a set of the schemas that
exist in the default catalog of the
current session.
SHOW SCHEMAS
See the “SHOW SESSION Command”
(page 142).
Displays attributes of the current NCI
session.
SHOW SESSION
See the “SHOW SQLPROMPT
Command” (page 144).
Displays the value of the SQL prompt
for the current session.
SHOW SQLPROMPT
See the “SHOW SQLTERMINATOR
Command” (page 144).
Displays the SQL statement terminator
of the current session.
SHOW SQLTERMINATOR
See the “SHOW STATISTICS
Command” (page 145)
Displays if statistics has been enabled
or disabled for the current session
SHOW STATISTICS
See the “SHOW SYNONYMS
Command” (page 145).
Displays all or a set of the synonyms
in the current schema of the NCI
session.
SHOW SYNONYMS
See the “SHOW TABLE Command”
(page 146).
Displays information about the
dependent objects (indexes,
materialized views, or synonyms) of a
specified table.
SHOW TABLE
See the “SHOW TABLES Command”
(page 148).
Displays all or a set of the tables that
exist in the current schema of the NCI
session.
SHOW TABLES
See the “SHOW TIME Command”
(page 150).
Displays the setting for the local time
in the SQL prompt.
SHOW TIME
91