15.10 - API Categories - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

PM/APIs and open APIs, also called SQL interfaces, are divided into the following categories:

  • System PMPC
  • Teradata Dynamic Workload Management
  • Query Band
  • Embedded services system is another category that applies only to some of the SQL interfaces (for example, the GetPSFVersion and TD_get_COD_limits functions).

    The following diagram shows how:

  • The System PMPC, Teradata Dynamic Workload Management, and Query Band PM/API requests (such as Call-Level Interface Version 2 [CLIv2] and the Teradata JDBC Driver) interface to the PMPC subsystem through the MONITOR partition.
  • Note: These PM/APIs are supported by both Call-Level Interface Version 2 (CLIv2) and the Teradata JDBC Driver. For more information on how the Teradata JDBC Driver requests are executed, see Teradata JDBC Driver Reference.

  • The System PMPC and Teradata Dynamic Workload Management SQL interfaces (such as, user-defined functions and external stored procedures) connect to the PMPC subsystem through the SQL partition, except TDWMApply, TDWMRuleControl, and TDWMSetLimits. These APIs connect to the Teradata Database system through the SQL partition and are not shown in the diagram below.
  • The embedded services system and most Query Band SQL interfaces connect to the SQL partition, except MonitorQueryband. This SQL interface is the only Query Band API that connects to the PMPC subsystem through the SQL partition and is not shown in the diagram below.
  • For more information on these APIs, see:

  • Chapter 3: “Workload Management API Features and Examples”
  • Chapter 4: “System PMPC APIs”
  • Chapter 5: “Teradata Dynamic Workload Management APIs”
  • Chapter 6: “Query Band APIs”
  • Chapter 7: “Embedded Services System APIs”