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

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
Output of /usr/home/b.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 stops the logging process:
SQL>log off
For more information, see “Logging output” (page 66).
OBEY command
The obey command runs the SQL statements and RMXCI commands of a specified script file or
an entire directory. This command accepts a single filename or a filename with a wildcard pattern
specified. Executing the obey command without optional parameters prompts you to enter a
filename. If a filename is not specified, then *.sql is used.
Syntax
OBEY [script-file | wild-card pattern ] [ <section-name> ]
script-file
is the name of an ASCII text file that contains SQL statements, RMXCI commands, and comments.
If the script file exists outside the local directory where you launch RMXCI , specify the full
directory path of the script file.
(section-name)
is the name of a section within the script-file. If you specify section-name, the obey
command runs the commands between the header line for the specified section and the header
96 RMXCI commands