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

SyntaxDescriptionCommand
See the “SHOW SQLPROMPT
command” (page 134).
Displays all or a set of tables that exist
in the current catalog and schema for
the RMXCI session.
SHOW TABLES
See the “SHOW SQLTERMINATOR
command” (page 134).
Displays the SQL statement terminator
of the current session.
SHOW SQLTERMINATOR
See the “SHOW STATISTICS
command” (page 134)
Displays if statistics has been enabled
or disabled for the current session
SHOW STATISTICS
See the “SHOW TIME command”
(page 136).
Displays the setting for the local time in
the SQL prompt.
SHOW TIME
See the “SHOW TIMING command”
(page 136).
Displays the setting for the elapsed time.SHOW TIMING
See the “SHOW VIEWS command”
(page 137).
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 138).Logs commands and output from RMXCI
to a log file.
SPOOL
See the “VERSION command”
(page 140).
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 96).
Syntax
@
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 on a Linux client
workstation:
SQL>@./my_files/ddl.sql
• The following @ command runs the script file in the specified directory a Windows client
workstation:
SQL>@c:\my_files\ddl.sql
/ command
The / command runs the previously run SQL statement. This command does not run an RMXCI
command.
Syntax
/
@ command 79