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

• 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
SQL>select * from neo.toi.job
+>;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
200 PRODUCTION SUPV
--- 10 row(s) selected.
SQL> log off
Output of c:\temp\a.txt
====================
JOBCODE JOBDESC
------- ------------------
100 MANAGER
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
SPOOL Command 149