Neoview Script Guide (R2.2)

SyntaxDescriptionCommand
See the “SHOW LIST_COUNT
Command” (page 121).
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 122).
Displays the value that has been set for
the markup option for the current
Neoview Script session.
SHOW MARKUP
See the “SHOW MODE Command”
(page 122).
Displays the operating mode of the
current session.
SHOW MODE
See the “SHOW MVGROUPS
Command” (page 122).
Displays all or a set of the materialized
view groups in the current schema of
the Neoview Script session.
SHOW MVGROUPS
See the “SHOW MVS Command”
(page 123).
Displays all or a set of the materialized
views in the current schema of the
Neoview Script session.
SHOW MVS
See the “SHOW PARAM Command”
(page 125).
Displays the parameters that are set in
the current session.
SHOW PARAM
See the “SHOW PREPARED
Command” (page 125).
Displays the prepared statements in
the current Neoview Script session.
SHOW PREPARED
See the “SHOW PROCEDURES
Command” (page 126).
Displays the procedures (Stored
Procedures in Java) in the current
schema of the Neoview Script session.
SHOW PROCEDURES
See the “SHOW SCHEMA Command”
(page 127).
Displays the current schema of the
Neoview Script session.
SHOW SCHEMA
See the “SHOW SCHEMAS
Command” (page 127).
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 128).
Displays attributes of the current
Neoview Script session.
SHOW SESSION
See the “SHOW SQLPROMPT
Command” (page 130).
Displays the value of the SQL prompt
for the current session.
SHOW SQLPROMPT
See the “SHOW SQLTERMINATOR
Command” (page 131).
Displays the SQL statement terminator
of the current session.
SHOW SQLTERMINATOR
See the “SHOW SYNONYMS
Command” (page 131).
Displays all or a set of the synonyms
in the current schema of the Neoview
Script session.
SHOW SYNONYMS
See the “SHOW TABLE Command”
(page 132).
Displays information about the
dependent objects (indexes,
materialized views, or synonyms) of a
specified table.
SHOW TABLE
See the “SHOW TABLES Command”
(page 134).
Displays all or a set of the tables that
exist in the current schema of the
Neoview Script session.
SHOW TABLES
See the “SHOW TIME Command”
(page 135).
Displays the setting for the local time
in the SQL prompt.
SHOW TIME
See the “SHOW TIMING Command”
(page 135).
Displays the setting for the elapsed
time.
SHOW TIMING
See the “SHOW VIEWS Command”
(page 136).
Displays all or a set of the views that
exist in the current schema of the
Neoview Script session.
SHOW VIEWS
See the “SPOOL Command”
(page 137).
Logs commands and output from the
Neoview Script interface to a log file.
SPOOL
See the “VERSION Command”
(page 138).
Displays the build versions of Neoview
Script and the Neoview JDBC Type 4
Driver.
VERSION
85