Screen Format - Interactive Teradata Query Facility

Interactive Teradata Query Reference

Product
Interactive Teradata Query Facility
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2451
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 Format

Each area is described in the following paragraphs:

  • The display area
  • 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
  • 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
  • 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.

     

    Table 1: ITEQ 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.