BTEQ Process - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

BTEQ Process

This section describes the BTEQ process.

Note: For a more detailed description of the Teradata Database system components and their roles in processing input and output, see Introduction to Teradata.

1 Issue BTEQ commands and submit SQL requests in a batch- or interactive-mode BTEQ session.

2 The Call-Level Interface (CLI) packages the input and forwards it to the Teradata Director Program (TDP), in mainframe-attached systems, or the Micro Teradata Director Program (MTDP) in workstation-attached systems.

3 The TDP, or MTDP, establishes a session and manages communication between the CLI and the Teradata server.

4 The Teradata Server parses, interprets, plans access for, and dispatches the request to the Teradata Database.

5 The Teradata Database processes the request and sends a response message back to the TDP or MTDP.

6 The TDP, or MTDP, unpackages the response and makes it available to the CLI.

7 The CLI makes the response available to BTEQ, which routes the output to the specified terminal, file, or printer.