This section describes the BTEQ process.
For a more detailed description of the Teradata Database system components and their roles in processing input and output, see Introduction to Teradata (B035-1091).
- Issue BTEQ commands and submit SQL requests in a batch- or interactive-mode BTEQ session.
- 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.
- The TDP, or MTDP, establishes a session and manages communication between the CLI and the Teradata server.
- The Teradata Server parses, interprets, plans access for, and dispatches the request to the Teradata Database.
- The Teradata Database processes the request and sends a response message back to the TDP or MTDP.
- The TDP, or MTDP, unpackages the response and makes it available to the CLI.
- The CLI makes the response available to BTEQ, which routes the output to the specified terminal, file, or printer.