Open APIs (SQL Interfaces) - Teradata Database - Teradata Vantage NewSQL Engine

Application Programming Reference

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
vwf1492987142269.ditamap
dita:ditavalPath
changebar_rev_16_20_exclude_audience_ie.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantageā„¢

This section describes the Teradata Dynamic Workload Management SQL interfaces that are used to manage the workload and update the stored components (such as, WDs and related data) in the Teradata Dynamic Workload Management. These SQL interfaces consist of UDFs and external stored procedures that you can invoke from any application.

The SQL interfaces to workload management are installed by the DIPTDWM script as part of the Teradata Database installation (see Requirements for Using the API).

These SQL interfaces provide similar functionality to the Teradata Dynamic Workload Management CLIv2 or Teradata JDBC Driver requests.

When issuing Teradata dynamic workload management software UDFs or calling Teradata dynamic workload management software external stored procedures, you must fully qualify them by the database name, TDWM.

For examples of Teradata dynamic workload management software functions and external stored procedures, see the following topics.