Figure 8 shows a diagram of how ISQL divides your display.
Figure 8. DB2 Server for VSE & VM Display Format
+--------------------------------------------------------------------------------+ | | | | | | | | | | | | | | | | | | | | | OUTPUT AREA | | | | | | | | | | | | | | | | | | | | | | | |------------------------------------------------------------------------------- | | INPUT AREA | |------------------------------------------------------------------------------- | | STATUS AREA | +--------------------------------------------------------------------------------+
The bottom line is the status area. Here, ISQL provides brief messages which indicate its current status during your terminal session. For example, whenever Enter a command appears, you know ISQL is ready to receive another command.
| Note: | For the remainder of this chapter, the general term command indicates ISQL commands, SQL statements and data. |
You type commands in the input area, which is just above the status area. The input area consists of a single line and begins at the second-character position of the line. You do not have to move the cursor to this location; it is placed there by the database manager.
Although the --> cursor-movement key can be used to leave a blank space in the input line, it does not provide a blank character as does the space bar. Use the space bar to insert a blank character; use the cursor key to move the cursor.
The input area is also used by ISQL to provide the following message:
ARI7044I Command in progress. Terminal is now free.
This message, displayed when you have typed a command that is taking longer to execute than a preset amount of time, is meant for users involved with more than one CICS transaction. This message is only displayed if the ISQL user is connected to a local application server. ISQL is one of several CICS transactions available at your terminal. If you are not involved with multiple CICS transactions, ignore the message and wait for the command to complete. If you are involved with multiple CICS transactions and want to issue another CICS transaction while waiting for the command to be completed, this message indicates the terminal is free to do so. To enter another CICS transaction in response to this message, press CLEAR and type the desired CICS transaction identifier code. The transaction must not be pseudoconversational. For more information, see the DB2 Server for VSE System Administration and DB2 Server for VM System Administration manuals.
The output area displays information typed in the input area. It is also used to display any database manager responses to your input. Specific uses of the output area are discussed where appropriate in the manual.
A diagram of the way ISQL divides your display is shown in Figure 9.
Figure 9. DB2 Server for VSE & VM Display Format
+--------------------------------------------------------------------------------+ | | | | | | | | | | | | | | | | | | | | | | | OUTPUT AREA | | | | | | | | | | | | | | | | | | | | | | | |--------------------------------------------------------------------------------| | INPUT AREA | | --------------------------| | | STATUS AREA | +--------------------------------------------------------------------------------+
The last 21 characters of the bottom line are the status area. Here, the current VM system status is displayed during your terminal session. For example, when the VM READ message appears, you know that the system is ready to receive another command from you.
You type commands and data in the input area, which includes all of the line above the status area and the part of the next line that is to the left of the status area. The input area begins at the second character position of the display. You do not have to move the cursor to this location; it is placed there by the ISQL system.
The key marked --> only moves the cursor. This key does not insert blank characters into an input line. To insert a blank character, you must use the space bar.
The output area displays your commands and data after they are typed in the input area. It also displays ISQL status messages and any database manager responses to your input. Specific uses of the output area are discussed where appropriate in the manual.
ISQL status messages are displayed as informational or ARI-type messages. They appear on the last line of the output area.
The command line is usable at all times. You can type commands or statements even while others are being processed. For example, you can type a SELECT statement and then several FORMAT commands before the query results are displayed.
VM also permits you to stack commands. Commands are stored in the console stack; VM will then execute them one at a time.