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

SyntaxDescriptionCommand
See the “SHOW SQLTERMINATOR
command” (page 111).
Displays the SQL statement terminator
of the current session.
SHOW SQLTERMINATOR
See the “SHOW STATISTICS
command” (page 112)
Displays if statistics has been enabled
or disabled for the current session
SHOW STATISTICS
See the “SHOW TIME command”
(page 113).
Displays the setting for the local time in
the SQL prompt.
SHOW TIME
See the “SHOW TIMING command”
(page 113).
Displays the setting for the elapsed time.SHOW TIMING
See the “SHOW VIEWS command”
(page 114).
Displays all or a set of the views that
exist in the current schema of the RMXCI
session.
SHOW VIEWS
See the “SPOOL command” (page 115).Logs commands and output from RMXCI
to a log file.
SPOOL
See the “VERSION command”
(page 117).
Displays the build versions of
Connectivity Services, Platform, Type 4
Driver, and RMXCI.
VERSION
NOTE: Most of the RMXCI commands do not need an SQL terminator. For the commands that
require an SQL terminator, see the Considerations section for the command.
@ command
The @ command runs the SQL statements and RMXCI commands contained in a specified script
file. The @ command is run in the same way as the obey command. For more information on syntax
and considerations, see the “OBEY command” (page 74).
Examples
• The following @ command runs the script file from the local directory :
SQL>@ddl.sql
• The following @ command runs the script file in the specified directory :
SQL>@./my_files/ddl.sql
/ command
The / command runs the previously run SQL statement. This command does not run an RMXCI
command.
Syntax
/
Considerations
You must enter the command in one line.
Example
The following / command runs the previously run SELECT statement:
SQL>select count(*) from persnl.employee;
(EXPR)
--------------------
62
@ command 57