Neoview Script Guide (R2.2)

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 61).
SPOOL Command
The SPOOL command logs the entered commands and their output from the Neoview Script
interface to a log file.
Syntax
SPOOL { ON [CLEAR] | log-file [CLEAR] | OFF }
ON
starts the logging process and records information in the sqlspool.lst file in the Neoview
Script bin directory.
ON CLEAR
instructs Neoview Script to clear the contents of the sqlspool.lst file before logging new
information to the file.
log-file
is the name of a log file into which Neoview Script records the entered commands and their
output. If you want the log file to exist outside the local directory where you launch Neoview
Script (by default, the Neoview Script 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.
log-file CLEAR
instructs Neoview Script to clear the contents of the specified log-file before logging new
information to the file.
OFF
stops the logging process.
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
• Use a unique name for each log file to avoid writing information from different Neoview
Script sessions into the same log file.
Examples
• This command starts the logging process and records information to the sqlspool.lst
file in the Neoview Script bin directory:
SPOOL Command 137