SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

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 in the
sqlspool.lst file in the RMXCI install directory:
SQL>spool on
• The following command starts the logging process and appends new information to an existing
log file, persnl_updates.log, in the RMXCI install directory:
SQL>spool 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>spool ./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>spool persnl_ddl.log clear
• 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 RMXCI install 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 must not be displayed in the log file:
SQL>log /usr/home/tmp/a.txt clear, cmdtext off
SQL>select * from cat.toi.job
+>;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
116 RMXCI commands