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

Examples
• The following command shows all the views that exist in the current schema, invent:
SQL>show schema
SCHEMA INVENT
SQL>show views
VIEW NAMES
-------------------------------------------------------------
VIEW207 VIEW207N VIEWCS VIEWCUST
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 38).
SPOOL command
The spool command logs the entered commands and their output from RMXCI to a log file.
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.
SPOOL command 115