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

SyntaxDescriptionCommand
See the “SHOW MVS Command”
(page 132).
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 134).
Displays the parameters that are set in
the current session.
SHOW PARAM
See the “SHOW PREPARED
Command” (page 134).
Displays the prepared statements in
the current NCI session.
SHOW PREPARED
See the “SHOW PROCEDURES
Command” (page 135).
Displays the procedures (Stored
Procedures in Java) in the current
schema of the NCI session.
SHOW PROCEDURES
See the “SHOW RECCOUNT
Command” (page 136).
Displays the record count of the
previous executed SQL statement.
SHOW RECCOUNT
See the “SHOW ROLE Command”
(page 136).
Displays the Neoview role in which
you are currently logged on during an
NCI session.
SHOW ROLE
See the “SHOW SCHEMA Command”
(page 137).
Displays the current schema of the NCI
session.
SHOW SCHEMA
See the “SHOW SCHEMAS
Command” (page 137).
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 138).
Displays attributes of the current NCI
session.
SHOW SESSION
See the “SHOW SQLPROMPT
Command” (page 140).
Displays the value of the SQL prompt
for the current session.
SHOW SQLPROMPT
See the “SHOW SQLTERMINATOR
Command” (page 140).
Displays the SQL statement terminator
of the current session.
SHOW SQLTERMINATOR
See the “SHOW STATISTICS
Command” (page 141)
Displays if statistics has been enabled
or disabled for the current session
SHOW STATISTICS
See the “SHOW SYNONYMS
Command” (page 141).
Displays all or a set of the synonyms
in the current schema of the NCI
session.
SHOW SYNONYMS
See the “SHOW TABLE Command”
(page 143).
Displays information about the
dependent objects (indexes,
materialized views, or synonyms) of a
specified table.
SHOW TABLE
See the “SHOW TABLES Command”
(page 145).
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 146).
Displays the setting for the local time
in the SQL prompt.
SHOW TIME
See the “SHOW TIMING Command”
(page 146).
Displays the setting for the elapsed
time.
SHOW TIMING
See the “SHOW VIEWS Command”
(page 146).
Displays all or a set of the views that
exist in the current schema of the NCI
session.
SHOW VIEWS
See the “SPOOL Command”
(page 148).
Logs commands and output from NCI
to a log file.
SPOOL
See the “VERSION Command”
(page 150).
Displays the build versions of
Connectivity Services, Platform, Type
4 Driver, and NCI.
VERSION
74 NCI Commands