User's Guide Part II. Tutorials Chapter 6. Using Character-Mode ISQLWhen you type the command
SELECT * FROM employee
in the ISQL command window, the visible portion of the ISQL data window cannot hold the entire employee table.
The visible portion of the data window does not display all the information about each employee, and does not display the entire list of employees.
To see more information about each employee (that is, other columns) you use the move left and move right operations. These operations can be done by choosing Left and Right from the Data menu. If your computer has a mouse, you can also move right by using the scroll bar at the bottom of the data window.
The employee table in the sample database has information on 75 employees. To see more information on other employees (that is, other rows), use the Page Down and Page Up keys. Try pressing the Page Down key, and observe that a new screen full of employees is shown. Continue pressing Page Down. and eventually the screen contains only the column names with no rows. Pressing Page Up. at this point will bring back the last screen full of employees in the employee table.
If your computer has a mouse, you can also move the information up and down using the scroll bar on the right side of the screen. Sometimes, this scroll bar behaves slightly differently than standard scroll bars when the number of rows in the result is unknown. In this case, a guess as to the number of rows is used. When ISQL determines that the guess is wrong, it will be adjusted and the slider "jumps".
The Data menu contains items for moving up and down a line. It also has items for going to the top and bottom of the query. These actions can also be performed with Ctrl+Page Down and Ctrl+Page Up. Ctrl + Pageg Down is actually two keys; hold down the Ctrl key and press the Page Downkey. When you do this, ISQL displays the last screen of employees in the employee table. Similarly, Ctrl+Page Up will display the first screen of employees. You can move back to the original position by using Ctrl+Page Up and then pressing the Left Arrow key until the emp_id column appears.