Command | Description | Syntax |
|
|
|
SHOW MVGROUPS | Displays all or a set of the | See the “SHOW MVGROUPS |
| materialized view groups in the | |
| current schema of the Neoview Script |
|
| session. |
|
|
|
|
SHOW MVS | Displays all or a set of the | See the “SHOW MVS Command” |
| materialized views in the current | |
| schema of the Neoview Script session. |
|
|
|
|
SHOW PARAM | Displays the parameters that are set | See the “SHOW PARAM Command” |
| in the current session. | |
|
|
|
SHOW PREPARED | Displays the prepared statements in | See the “SHOW PREPARED |
| the current Neoview Script session. | |
|
|
|
SHOW SCHEMA | Displays the current schema of the | See the “SHOW SCHEMA Command” |
| Neoview Script session. | |
|
|
|
SHOW SCHEMAS | Displays all or a set of the schemas | See the “SHOW SCHEMAS Command” |
| that exist in the default catalog of the | |
| current session. |
|
|
|
|
SHOW SESSION | Displays attributes of the current | See the “SHOW SESSION Command” |
| Neoview Script session. | |
|
|
|
SHOW SQLPROMPT | Displays the value of the SQL prompt | See the “SHOW SQLPROMPT |
| for the current session. | |
|
|
|
SHOW SQLTERMINATOR | Displays the SQL statement | See the “SHOW SQLTERMINATOR |
| terminator of the current session. | |
|
|
|
SHOW SYNONYMS | Displays all or a set of the synonyms | See the “SHOW SYNONYMS |
| in the current schema of the Neoview | |
| Script session. |
|
|
|
|
SHOW TABLE | Displays information about the | See the “SHOW TABLE Command” |
| dependent objects (indexes, | |
| materialized views, or synonyms) of |
|
| a specified table. |
|
|
|
|
SHOW TABLES | Displays all or a set of the tables that | See the “SHOW TABLES Command” |
| exist in the current schema of the | |
| Neoview Script session. |
|
|
|
|
SHOW TIME | Displays the setting for the local time | See the “SHOW TIME Command” |
| in the SQL prompt. | |
|
|
|
SHOW TIMING | Displays the setting for the elapsed | See the “SHOW TIMING Command” |
| time. | |
|
|
|
SHOW VIEWS | Displays all or a set of the views that | See the “SHOW VIEWS Command” |
| exist in the current schema of the | |
| Neoview Script session. |
|
|
|
|
SPOOL | Logs commands and output from the | See the “SPOOL Command” (page 130). |
| Neoview Script interface to a log file. |
|
|
|
|
VERSION | Displays the build versions of | See the “VERSION Command” |
| Neoview Script and the JDBC Type 4 | |
| Driver. |
|
|
|
|
@ Command
The @ command executes the SQL statements and Neoview Script interface commands contained in a specified script file.
Syntax
@ Command 81