17.00 - 17.05 - Software Components - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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


"Mainframe-attached system"

The following table describes these software components.

Component Description
Client application
  • Written by a developer in your company
  • Written under contract to you by Teradata
  • One of the Vantage-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, B035-2446.

CLIv2 A low-level interface to Vantage. 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, B035-2417 or Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418.

TDP Manages communication between mainframe clients and Vantage. 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)

For more information, see TDP Functionality and Teradata® Director Program Reference, B035-2416.