Software Components - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Software Components

The following figure illustrates the software components in mainframe-attached clients that play important roles in getting requests to and from Teradata Database.

The following table describes these software components.




Client application

  • Written by a developer in your company
  • Written under contract to you by Teradata
  • One of the Teradata Database-provided utilities
  • Users use these applications to submit SQL statements, maintain files, and generate reports.

    For details on supported programming languages, the Teradata Preprocessor2, and embedded SQL requirements, see Teradata Preprocessor2 for Embedded SQL Programmer Guide.


    A low-level interface to Teradata Database. It consists of system calls that:

  • Create sessions
  • Allocate request and response buffers
  • Create and deblock parcels of information
  • Fetch response information for the requesting client.
  • For more information, see Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems or Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems.


    Manages communication between mainframe clients and Teradata Database. Functions include:

  • Session initiation and termination
  • Logging, verification, recovery, and restart of client applications
  • Physical input to or output from PE vprocs
  • Security
  • Session balancing across multiple PEs
  • Control of the default client character set to be used during sessions originating through this TDP (unless overridden by the user with a BTEQ.SET SESSION CHARSET command)
  • See “TDP Functionality” on page 428 and Teradata Director Program Reference.