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

• If you specify a wild-card pattern in a SHOW VIEWS command, NCI displays only the view
names that match the wild-card pattern.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Examples
• This command shows all the views that exist in the current schema, SALES:
SQL>show schema
SCHEMA INVENT
SQL>show views
VIEW NAMES
-------------------------------------------------------------
VIEW207 VIEW207N VIEWCS VIEWCUST
SQL>
• This command shows the views in the current schema, INVENT, that have “VIEW” at the
beginning of their names:
SQL>show views view%
VIEW NAMES
-------------------------------------------------------------
VIEW207 VIEW207N VIEWCS VIEWCUST
SQL>
For more information, see “Showing the Views in a Schema” (page 65).
SPOOL Command
The SPOOL command logs the entered commands and their output from the NCI to a log file.
Syntax
SPOOL { ON [CLEAR, QUIET, CMDTEXT {ON | OFF}] | log-file [CLEAR, QUIET, CMDTEXT {ON | OFF}] | OFF }
ON
starts the logging process and records information in the sqlspool.lst file in the NCI bin
directory.
ON CLEAR
instructs NCI to clear the contents of the sqlspool.lst file before logging new information
to the file.
QUIET
specifies that the command text is displayed on the screen, but the results of the command
are written only to the log file and not to the screen.
CMDTEXT ON
specifies that the command text and the log header are displayed in the log file.
CMDTEXT OFF
specifies that the command text and the log header are not displayed in the log file.
log-file
is the name of a log file into which NCI records the entered commands and their output. If
you want the log file to exist outside the local directory where you launch NCI (by default,
the NCI bin directory), specify the full directory path of the log file. The log file does not
need to exist, but the specified directory must exist before you execute the SPOOL command.
SPOOL Command 155