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.