Filter
Top Products
SyntaxDescriptionCommand
See the “SHOW MVGROUPS
Command” (page 116).
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 117).
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 118).
Displays the parameters that are set
in the current session.
SHOW PARAM
See the “SHOW PREPARED
Command” (page 119).
Displays the prepared statements in
the current Neoview Script session.
SHOW PREPARED
See the “SHOW SCHEMA Command”
(page 120).
Displays the current schema of the
Neoview Script session.
SHOW SCHEMA
See the “SHOW SCHEMASCommand”
(page 120).
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 122).
Displays attributes of the current
Neoview Script session.
SHOW SESSION
See the “SHOW SQLPROMPT
Command” (page 123).
Displays the value of the SQL prompt
for the current session.
SHOW SQLPROMPT
See the “SHOW SQLTERMINATOR
Command” (page 124).
Displays the SQL statement
terminator of the current session.
SHOW SQLTERMINATOR
See the “SHOW SYNONYMS
Command” (page 124).
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 125).
Displays information about the
dependent objects (indexes,
materialized views, or synonyms) of
a specified table.
SHOW TABLE
See the “SHOW TABLES Command”
(page 127).
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 128).
Displays the setting for the local time
in the SQL prompt.
SHOW TIME
See the “SHOW TIMING Command”
(page 129).
Displays the setting for the elapsed
time.
SHOW TIMING
See the “SHOW VIEWS Command”
(page 129).
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 130).Logs commands and output from the
Neoview Script interface to a log file.
SPOOL
See the “VERSION Command”
(page 131).
Displays the build versions of
Neoview Script and the JDBC Type 4
Driver.
VERSION
@ Command
The @ command executes the SQL statements and Neoview Script interface commands contained
in a specified script file.
Syntax
@script-file [ (section-name )]
@ Command 81