Let's execute another command. Type the following and then press &doit.:
SELECT *FROM department
The contents of the department database table are displayed in the Data window. As you execute commands with ISQL, they are saved in a command history. To recall commands, choose Recall from the Command menu. This activates the command recall window. The window displays the first line of the last 15 commands that you have executed. Use the cursor up and down keys to scroll through the commands. As you do so, the full command appears in the command window at the bottom of the screen.
Position the cursor on the first command that you executed, which was:
SELECT *FROM employee
Now press the Enter key. The cursor will return to the command window with that command in it. You can now re-execute that command or you can modify it to make a new command.
The following keys can also be used to recall previous commands:
Ctrl+R bring up the command recall window.
Ctrl+P cycles backwards through previously executed commands. Retrieved commands are placed into the command window.
Ctrl+N cycles forward through previously executed commands.