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

A RMXCI commands
The NonStop SQL/MX Remote Conversational Interface supports these commands in RMXCI or in
script files. See the README for the HP NonStop SQL/MX Remote Conversational Interface for
syntax, considerations, and examples regarding conditional statements.
SyntaxDescriptionCommand
See the “@ command” (page 79).Runs the SQL statements and RMXCI
commands contained in a specified
@
script file. This command is disallowed
from Perl and Python programs.
See the “/ command” (page 79).Runs the previously run SQL statement./
See the “ALIAS command” (page 80).Maps a string to any RMXCI or SQL
command.
ALIAS
See the “CLEAR command” (page 81).Clears the command console so that
only the prompt appears at the top of
the screen.
CLEAR
See the “CONNECT command”
(page 81).
Creates a new connection to the
SQL/MX database from a current or
existing RMXCI session.
CONNECT
“DELAY command” (page 82)Allows the RMXCI session to be in sleep
mode for the specified interval.
DELAY
See the “DISCONNECT command”
(page 83).
Terminates the connection to the
SQL/MX database.
DISCONNECT
See the “ENV command” (page 83).Displays attributes of the current RMXCI
session.
ENV
See the “EXIT command” (page 86).Disconnects from the SQL/MX database
and exits RMXCI.
EXIT
See the “FC command” (page 86).Edits and reruns a previous command.
This command is restricted to the RMXCI
FC
interface and is disallowed in script
files, Perl and Python programs.
See the “GET STATISTICS command”
(page 89).
Returns formatted statistics for the last
run SQL statement.
GET STATISTICS
See the “GOTO command” (page 90).Jumps to a point in the command list
specified by the “LABEL command”
(page 93).
GOTO
See the “LOCALHOST command”
(page 93).
Displays help text for the interface
commands that are supported in the
current operating mode.
HELP
See the “HISTORY command”
(page 91).
Displays recently run commands.HISTORY
See the “IF...THEN command”
(page 91).
Allows the conditional execution of
actions specified within the IF...THEN
conditional statement.
IF...THEN
See the “LABEL command” (page 93).Marks a point in the command list that
you can jump to by using the GOTO
command.
LABEL
See the “LOCALHOST command”
(page 93).
Runs client machine commands.LOCALHOST
See the “LOG command” (page 94).Logs commands and output from RMXCI
to a log file.
LOG
76 RMXCI commands