Software Components - Advanced SQL Engine

Software Components - Advanced SQL Engine - Teradata Database

Database Administration

Product

Advanced SQL Engine

Teradata Database

Release Number

17.05

17.00

Published

June 2020

Language

English (United States)

Last Update

2021-01-22

dita:mapPath

rgu1556127906220.ditamap

dita:ditavalPath

lze1555437562152.ditaval

dita:id

B035-1093

lifecycle

Product Category

Teradata Vantage™

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

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.

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.