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

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:
SQL>selt * fromm persnl.employee;
*** ERROR[15001] A syntax error occurred at or before:
selt * fromm persnl.employee;
^
SQL>fc
SQL>selt * fromm persnl.employee;
.... iec// d
SQL>select * from persnl.employee;
....
Pressing Enter runs the corrected SELECT statement.
• The following example modifies a previously run statement by replacing a column name in
the select list with another column name:
SQL>select first_name, last_name
+>from persnl.employee
+>where jobcode=450;
FIRST_NAME LAST_NAME
--------------- --------------------
MANFRED CONRAD
WALTER LANCASTER
JOHN JONES
KARL HELMSTED
THOMAS SPINNER
--- 5 row(s) selected.
SQL>fc
SQL>select first_name, last_name
.... R empnum,
SQL>select empnum, last_name
....
SQL>from persnl.employee
....
SQL>where jobcode=450;
....
Pressing Enter lists the employee number and last names of all employees whose job code
is 450:
EMPNUM LAST_NAME
------ --------------------
180 CONRAD
215 LANCASTER
88 RMXCI commands