NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-2
Examples—FC
To terminate a command and to specify more than one editing command on a line,
separate the editing commands with a double slash (//).
When you have no further changes to make, press the Return key. The command
prints again to allow you to edit it again. To stop editing, press the Return key
without entering any editing commands.
After you modify the last line and accept it by pressing the Return key, the revised
command executes.
•
To abort the FC command and leave the original command unchanged, press the
Break key or Control-Y or enter a double slash (//) in columns 1 and 2, followed
immediately by a the Return key.
Examples—FC
•
To correct the last statement or command entered, use FC without text or a number:
>> EXEUCTE SELSUPP USING ?ST = "CALIFORNIA";
^
*** ERROR from SQLCI [-10021] Syntax error.
>> FC
>> EXEUCTE SELSUPP USING ?ST = "CALIFORNIA";
.. CU
>> EXECUTE SELSUPP USING ?ST = "CALIFORNIA";
..
Press the Return key to execute the corrected version.
•
Suppose you want to display information about a specific supplier. You enter a
query to select supplier number 4, and learn that the supplier number does not exist.
You then decide to list all suppliers, but want only five rows displayed at a time.
>> SELECT SUPPNAME, CITY, STATE FROM INVENT.SUPPLIER
+> WHERE SUPPNUM = 4;
-- 0 row(s) selected.
>> SET LIST_COUNT 5;