Neoview Command Interface (NCI) Guide (R2.4)
log-file CLEAR
instructs NCI to clear the contents of the specified log-file before logging new information
to the file.
OFF
stops the logging process.
Considerations
• 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 NCI sessions
into the same log file.
• This command works in all modes.
Examples
• This command starts the logging process and records information to the sqlspool.lst
file in the NCI 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
NCI):
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 starts the logging process and records information to the sqlspool.lst
file in the NCI bin directory:
SQL>log 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
NCI):
SQL>log 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>log 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>log ./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>log persnl_ddl.log clear
• This command start the logging process, clears existing information from the log file, and
specifies that the command text and log header is not displayed in the log file:
SQL>log c:\temp\a.txt clear, cmdtext off
156 NCI Commands