You can correct a typing error in the input area by backspacing and typing the correct characters before you press ENTER.
If you press ENTER before you notice the typing error, the command or statement containing the typing error is displayed in the output area. It is no longer in the input area. You cannot backspace and retype information already in the output area.
To correct a mistake in a multiple-line command, type the following ISQL command at the beginning of the input area and press ENTER.
ignore
ISQL responds by telling you that it has ignored all lines previously entered in a multi-line input.
| DB2 Server for VM |
|---|
|
The status area contains VM READ. You can then retype the information correctly. You can also use the CMS RETRIEVE function to review and correct typed information. CMS saves the lines that you have typed. |
To use the RETRIEVE function, press PF12 (or PF24).
This function retrieves the last line that you typed and redisplays it in the input area for review and correction. The cursor is positioned at the end of the displayed line. You can continue to press PF12 (or PF24) until the command you want to change is redisplayed in the input area. Then, you can make any necessary corrections and press ENTER.
Each time you press F12, ISQL retrieves another line and redisplays it in the input area. After the earlier line is retrieved, command retrieval begins again with the most recent command typed. ISQL retains a varying number of your commands depending on their size. The shorter the commands, the more ISQL retains. For more information on the RETRIEVE function, see Retrieving and Correcting SQL Lines.