SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-30

Examples of FC

•

Reexecute the most recent command that begins with SH:

>>FC SH;

>>SHOW SESSION;

Pressing Return executes the SHOW SESSION command.

•

Correct a statement entered incorrectly:

>>SELECR * FROM MYTABLE;

*** ERROR[15001] A syntax error at or before:

selecr * from $boy000.persnl.employee;

>>FC;

>>SELECR * FROM MYTABLE;

.. T

>>SELECT * FROM MYTABLE;

Pressing Return executes the corrected SELECT statement.

•

Modify a previously executed statement:

>>SELECT SUPPNAME, CITY, STATE

>+FROM INVENT.SUPPLIER

>+WHERE SUPPNUM = 4;

-- 0 row(s) selected.

>>FC;

>>SELECT SUPPNAME, CITY, STATE

>>FROM INVENT.SUPPLIER

>>WHERE SUPPNUM = 4;

..DDDDDDDDDDDDDDDDD

>>;

Pressing Return lists all of the suppliers.