MX Release 3.1 (H06.23+, J06.12+)

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

216 JONES

225 HELMSTED

232 SPINNER

--- 5 row(s) selected.

SQL>

GET STATISTICS command

The get statistics command returns formatted statistics for the last run SQL statement.

Syntax

GET STATISTICS

66 RMXCI commands