Hardware and Software Requirements - Interactive Teradata Query Facility

Interactive Teradata Query Reference

Product
Interactive Teradata Query Facility
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2451
Product Category
Teradata Tools and Utilities

ITEQ operates on IBM (or IBM-compatible) processors that support the MVS/370 and/or the MVS/XA architecture. ITEQ operates under the following operating systems:

  • MVS/TSO
  • VM/CMS
  • In the MVS environment, ITEQ requires MVS Level 3.8 or higher with the Time Sharing Option (TSO). Both VTAM (System Network Architecture, SNA, and non-SNA) and TCAM access methods are supported.

    In the VM/CMS environment, ITEQ requires Level 3.0 or higher. Access methods supported include native terminal attachment, VM PASSTHRU, and VTAM/VCNA (SNA or non-SNA).

    In both the MVS/TSO and VM/CMS environments, ITEQ terminal communication is in full screen mode. ITEQ sends and receives formatted 3270 data streams. ITEQ does not support SCS (SNA Character String) or SFAP (Structured Field and Attribute Processing).

    ITEQ supports IBM or IBM-compatible 3270 Information Display System devices with a screen size of at least 12 lines of 40 characters each. This includes the IBM 3275, 3276, 3277, 3278, and 3279 terminals in both local and remote configurations.

    ITEQ determines the screen size of a terminal internally and formats output accordingly. Output can be directed to the changed data sets to files terminal screen and/or to external files.

    ITEQ allows a user to:

  • Enter Teradata SQL statements
  • A user can enter and execute a Teradata SQL statement at a terminal. If the result of statement execution is unsatisfactory, the user can conveniently modify the statement without re-entering it.

  • View results
  • A user can browse through the result of a Teradata SQL statement, moving the screen horizontally or vertically over a result that exceeds the size of a single display.

  • Format data and reports
  • A user can easily format the result of a query for display on a terminal screen, for printing on a hardcopy device, or storing on a disk file.

  • Execute macros
  • A user can define and execute macros that contain one or several statements and ITEQ commands.

  • Control terminal operation
  • A user can define the use of program function (PF) keys on the terminal keyboard and adjust the format of information displayed on the screen.

  • Display and modify reference information
  • A user can:

  • Display Data Dictionary/Directory views.
  • Modify and replace view and macro definitions.
  • View and modify the last executed Teradata SQL statement.
  • View ITEQ controls currently in effect.