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

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.3 Software

101

102

103

104

105

106

107

108

109

110

Examples

• 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

====================