Screen Format
After the user invokes ITEQ, the ITEQ screen is displayed at the terminal. The ITEQ terminal screen is divided into three areas, shown in Figure 1: the display area, the input area, and the status area.
Figure 1: 1ITEQ Screen FormatEach area is described in the following paragraphs:
The display area, located at the top of the terminal screen, typically occupies the largest area of the screen. The size of this area varies, depending on the type of terminal that is being used and the size of the input area as the user adjusts it.
For a 3278-2 terminal operating under usual conditions, the display area occupies 20 screen lines, as shown in Figure 1-1. For other terminals, the size of the display area is determined by subtracting the size of input and status areas (normally 4 lines) from the total screen size.
In general, the display area is protected from input so that system responses from ITEQ commands and Teradata SQL statements can be displayed. The INPUT command can set the display area for input. Then, the display area is unprotected and the user can enter long Teradata SQL statements, create macros, or modify previously defined macros, views, or statements in the display area.
The input area occupies the three screen lines below the display area. This area is typically used for entering ITEQ commands and Teradata SQL statements, and contains an arrow (==>) to indicate its first line.
The input area is always set (unprotected) for input. During a terminal session, the user can adjust the size of the input area by using the SET INPUTAREA SIZE command.
The status area always occupies one line at the bottom of the terminal screen. It is always in output mode (protected), and is used to display the ITEQ version number, status messages, and system messages. The ITEQ version number is positioned in the far left area of the screen. Status and system messages are positioned to the far right of the area and bracketed by asterisks (***).
Table 1 summarizes the most common status and system messages.
Message |
Meaning |
COMMAND IN PROGRESS |
ITEQ is processing a command locally or has sent a statement to the Teradata DBS and is awaiting a response. |
DATA AVAILABLE. READY FOR COMMAND |
More data returned from the last data-generating command or statement (for example, SELECT) is available for viewing or printing. |
END OF DATA. READY FOR COMMAND |
The display area currently holds the last page of results from a data-generating command or statement. |
INCOMPLETE STATEMENT. READY FOR COMMAND |
The entered statement is incomplete either because the user forgot to end the statement with a semicolon or there are unbalanced comments, quote strings, or parameters. |
READY FOR COMMAND |
ITEQ is ready to accept a new command or Teradata SQL statement. |