Filter
Top Products
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:
SQL>spool on
• This command starts the logging process and appends new information to an existing log
file, persnl_updates.log, in the local directory (the same directory where you are running
Neoview Script):
SQL>spool persnl_updates.log
• This command starts the logging process and appends new information to a log file,
sales_updates.log, in the specified directory on a Windows workstation:
SQL>spool c:\log_files\sales_updates.log
• This command starts the logging process and appends new information to a log file,
sales_updates.log, in the specified directory on a Linux or UNIX workstation:
SQL>spool ./log_files/sales_updates.log
• This command starts the logging process and clears existing information from the log file
before logging new information to the file:
SQL>spool persnl_ddl.log clear
• This command stops the logging process:
SQL>spool off
For more information, see “Logging Output” (page 63).
VERSION Command
The VERSION command displays the build versions of Neoview Script and the JDBC Type 4
Driver.
Syntax
VERSION
VERSION Command 131