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

Considerations
• You must enter the command in one line.
• You cannot run this command in a script file. You can run this command only at a command
prompt.
• As each line of the command appears, you can modify the line by entering these editing
commands (in uppercase or lowercase letters) in the line below the displayed command-line:
Deletes the character immediately above the letter D. Repeat to delete more
characters.
D
Inserts characters in front of the character immediately above the letter I.Icharacters
Replaces existing characters one-for-one with characters, beginning with
the character immediately above the letter R.
Rcharacters
Replaces existing characters one-for-one with characters, beginning with
the first character immediately above characters. characters must begin
with a non blank character.
characters
To specify more than one editing command on a line, separate the editing commands with a
double slash (//). The end of a line terminates an editing command or a set of editing
commands.
After you edit a line of the command, RMXCI displays the line and allows you to re edit. Press
Enter without specifying editing commands to stop editing the line. The command runs when
you press Enter after the last line.
To terminate a command without saving the changes, use the double slash (//), and then
press Enter.
Examples
• The following example runs the most recently run command that begins with sh:
SQL>fc sh
SQL>show schema
....
Pressing Enter runs the show schema command and displays the current schema, PERSNL:
SQL>fc sh
SQL>show schema
....
SCHEMA PERSNL
SQL>
• The following example corrects an SQL statement that you entered incorrectly by using the
delete (D) editing command:
SQL>select * from persnl.employee;
*** ERROR[15001] A syntax error occurred at or before:
selecct * from persnl.employee;
^
SQL>fc
SQL>selecct * from persnl.employee;
.... d
SQL>select * from persnl.employee;
....
Press Enter to run the corrected SELECT statement.
• The following example corrects an SQL statement that you entered incorrectly by using more
than one editing command:
FC command 65