Entering Commands and Statements - Interactive Teradata Query Facility

Interactive Teradata Query Reference

Interactive Teradata Query Facility
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

The user may enter only one ITEQ command or Teradata SQL statement at a time. Each command or Teradata SQL statement must be delimited by a terminating semicolon:

commandkeyword parameters ;
statement ;

Commands and statements are typically entered in the input area. Long Teradata SQL statements needed to compose complex queries or to define tables, views, or macros, can be entered in the larger display area when it is set for input. When a request exceeds the size of the input area or display area, ITEQ edit commands allow the user to move backward or forward through the entire request.