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

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 57).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 57).Runs the previously run SQL statement./
See the “ALIAS command” (page 58).Maps a string to any RMXCI or SQL
command.
ALIAS
See the “CLEAR command” (page 59).Clears the command console so that
only the prompt appears at the top of
the screen.
CLEAR
See the “CONNECT command”
(page 59).
Creates a new connection to the
SQL/MX database from a current or
existing RMXCI session.
CONNECT
“DELAY command” (page 60)Allows the RMXCI session to be in sleep
mode for the specified interval.
DELAY
See the “DISCONNECT command”
(page 61).
Terminates the connection to the
NonStop platform.
DISCONNECT
See the “ENV command” (page 61).Displays attributes of the current RMXCI
session.
ENV
See the “EXIT command” (page 63).Disconnects from and exits the RMXCI
interface.
EXIT
See the “FC command” (page 64).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 66).
Returns formatted statistics for the last
run SQL statement.
GET STATISTICS
See the “GOTO command” (page 67).Jumps to a point in the command history
specified by the “LABEL command”
(page 71).
GOTO
See the “LOCALHOST command”
(page 71).
Displays help text for the interface
commands that are supported in the
current operating mode.
HELP
See the “HISTORY command”
(page 68).
Displays recently run commands.HISTORY
See the “IF...THEN command”
(page 69).
Allows the conditional execution of
actions specified within the IF...THEN
conditional statement.
IF...THEN
See the “LABEL command” (page 71).Marks a point in the command history
that you can jump to by using the
GOTO command.
LABEL
See the “LOCALHOST command”
(page 71).
Runs client machine commands.LOCALHOST
See the “LOG command” (page 72).Logs commands and output from RMXCI
to a log file.
LOG
54 RMXCI commands