15.00 - Examining Teradata SQL Statement Results - Interactive Teradata Query Facility

Interactive Teradata Query Reference

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
Programming Reference
featnum
B035-2451-034K

Examining Teradata SQL Statement Results

ITEQ provides responses on the terminal screen for all commands and statements that are processed, whether in a client system or in the Teradata DBS.

A response for a successfully executed statement includes:

  • The type of processing performed (for example, update)
  • Status of and statistics about the processing (for example, the number of records updated)
  • Processing results (for example, table rows selected)
  • A response for a statement that is not executed successfully consist of an error message. In either case, the response is displayed in the display area.

    The results of ITEQ commands are either explicit or implicit, depending on the command. Explicit response messages are displayed in the display area. Implicit responses are indicated by appropriate changes in screen content (for example, paging backward or forward over results).