SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

OFF
stops the logging process.
Considerations
• You must enter the command in one line.
• Use a unique name for each log file to avoid writing information from different RMXCI sessions
into the same log file.
Examples
• The following command starts the logging process and records information to the
sqlspool.lst file in the RMXCI install directory:
SQL>log on
• The following command starts the logging process and appends new information to an existing
log file, persnl_updates.log, in the local directory:
SQL>log persnl_updates.log
• On Linux, the following command starts the logging process and appends new information
to a log file, sales_updates.log, in the specified directory:
SQL>log ./log_files/sales_updates.log
On Windows, the following command starts the logging process and appends new information
to a log file, sales_updates.log, in the specified directory:
SQL>log C:\log_files\sales_updates.log
• The following 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
• On Linux, the following command starts 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 /usr/home/a.txt clear, cmdtext off
SQL>select * from sch.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 /usr/home/a.txt
====================
JOBCODE JOBDESC
------- ------------------
100 MANAGER
450 PROGRAMMER
LOG command 95