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

SyntaxDescriptionCommand
See the “SHOW PREPARED
Command” (page 142).
Displays the prepared statements in
the current NCI session.
SHOW PREPARED
See the “SHOW PROCEDURES
Command” (page 143).
Displays the procedures (Stored
Procedures in Java) in the current
schema of the NCI session.
SHOW PROCEDURES
See the “SHOW RECCOUNT
Command” (page 144).
Displays the record count of the
previous executed SQL statement.
SHOW RECCOUNT
See the “SHOW SCHEMA Command”
(page 144).
Displays the current schema of the NCI
session.
SHOW SCHEMA
See the “SHOW SCHEMAS
Command” (page 145).
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 146).
Displays attributes of the current NCI
session.
SHOW SESSION
See the “SHOW SQLPROMPT
Command” (page 148).
Displays the value of the SQL prompt
for the current session.
SHOW SQLPROMPT
See the “SHOW SQLTERMINATOR
Command” (page 148).
Displays the SQL statement terminator
of the current session.
SHOW SQLTERMINATOR
See the “SHOW STATISTICS
Command” (page 149)
Displays if statistics has been enabled
or disabled for the current session
SHOW STATISTICS
See the “SHOW SYNONYMS
Command” (page 149).
Displays all or a set of the synonyms
in the current schema of the NCI
session.
SHOW SYNONYMS
See the “SHOW TABLE Command”
(page 150).
Displays information about the
dependent objects (indexes,
materialized views, or synonyms) of a
specified table.
SHOW TABLE
See the “SHOW TABLES Command”
(page 152).
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 153).
Displays the setting for the local time
in the SQL prompt.
SHOW TIME
See the “SHOW TIMING Command”
(page 154).
Displays the setting for the elapsed
time.
SHOW TIMING
See the “SHOW VIEWS Command”
(page 154).
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 155).
Logs commands and output from NCI
to a log file.
SPOOL
See the “VERSION Command”
(page 158).
Displays the build versions of
Connectivity Services, Platform, Type
4 Driver, and NCI.
VERSION
@ Command
The @ command executes the SQL statements and NCI commands contained in a specified script
file. The @ command is executed the same as the OBEY command. For more information on
syntax and considerations, see the “OBEY Command” (page 109).
Examples
• This @ command runs the script file from the local directory (the same directory where you
are running NCI):
88 NCI Commands