User's Guide

Part II. Tutorials

Chapter 5. Using ISQL

Let's execute another command.

1. Type the following:

        SELECT * FROM department
   

2. Press F9.

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 Command->Recall from the menu bar. This activates the command recall window.

The command recall window displays the first line of the last 15 commands executed. Use the cursor up and down keys to scroll through the commands.

Position the cursor on the first command that you executed, which was:

     SELECT *
     FROM employee

and press the enter key. The cursor returns to the command window with the selected command in it. You can now re-execute that command or modify it to make a new command.

More recall keys

The following keys can also be used to recall previous commands:

Key sequence	Description
ctrl+r	Brings 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