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

--- SQL operation complete.
GOTO command
The goto command allows you to jump to a designated point later in the command list. The point
in the command list is indicated by a label. All commands run after a goto command are ignored
until the specified label is set. To set a label, use the “LABEL command” (page 93). The goto
command is typically used with the IF...THEN command, for conditional execution of other
commands. For IF...THEN command usage, see “IF...THEN command” (page 91) .
Syntax
GOTO {label}
label
is a string of characters without quotes and spaces, or a quoted string.
Considerations
You must enter the command in one line.
The goto command cannot jump back in the command history; it is a forward only command.
Examples
The following examples show the use of goto and label commands:
SQL> GOTO ViewManagers
SQL> SELECT * FROM Employees; -- skipped
SQL> SHOW RECCOUNT; -- skipped
SQL> LABEL ViewManagers
SQL> SELECT * FROM Managers;
SQL> GOTO View Customers
SQL> SELECT * FROM Invoices; -- skipped
SQL> LABEL View Customers
SQL> SELECT * FROM Customers;
HELP command
The help command displays help text for the supported interface commands.
Syntax
HELP [command-name]
command-name
is the name of an interface command. If you do not specify a command, RMXCI returns a list
of all supported commands. If you specify set, RMXCI returns a list of all set commands. If
you specify show, RMXCI returns a list of all show commands.
Considerations
You must enter the command in one line.
Examples
The following command lists all the commands:
90 RMXCI commands