SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)
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
• The following command starts the logging process and appends new information to a log file,
sales_updates.log, in the specified directory on client workstation:
SQL>log ./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
• 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
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
200 PRODUCTION SUPV
--- 10 row(s) selected
• The following command starts the logging process, clears existing information from the log
file, specifies that no output appears on the console window, and the quiet option is enabled:
SQL>log /usr/home/b.txt clear, cmdtext off, quiet
SQL>select *
+>from sch.toi.job;
SQL> log off
LOG command 73