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

SQL>
• The following command shows the views in the current schema, invent, in which their names
begin with, VIEW:
SQL>show views view%
VIEW NAMES
-------------------------------------------------------------
VIEW207 VIEW207N VIEWCS VIEWCUST
SQL>
For more information, see “Showing the views in a schema” (page 59).
SPOOL command
The spool command logs the entered commands and their output from RMXCI to a log file. This
command is an alternative to the log command.
Syntax
SPOOL { ON [CLEAR, QUIET, CMDTEXT {ON | OFF}] | log-file [CLEAR, QUIET, CMDTEXT {ON | OFF}] | OFF }
ON
starts the logging process and records information in the sqlspool.lst file in the RMXCI
bin directory.
ON CLEAR
instructs RMXCI to clear the contents of the sqlspool.lst file before logging new information
to the file.
QUIET
specifies that the command text appears on the screen, but the results of the command are
written only to the log file and not to the screen.
CMDTEXT ON
specifies that the command text and the log header are displayed in the log file.
CMDTEXT OFF
specifies that the command text and the log header are not displayed in the log file.
log-file
is the name of a log file into which RMXCI records the entered commands and their output. If
you want the log file to exist outside the RMXCI install directory, specify the full directory path
of the log file. The log file need not exist, but the specified directory must exist before you run
the spool command.
log-file CLEAR
instructs RMXCI to clear the contents of the specified log-file before logging new information
to the file.
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.
138 RMXCI commands