15.10 - Differences Between Open APIs and PM/APIs - Teradata Database

Teradata Database Application Programming Reference

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

The following table describes the differences between open APIs (that is, SQL interfaces consisting of UDFs or external stored procedures) and PM/APIs.

 

Open APIs...

PM/APIs...

are issued in the current SQL partition

require logging on to the MONITOR partition. To view a diagram of the process, see “API Categories” on page 17.

require EXECUTE privilege on the function or external stored procedure

require MONITOR privileges.

use SQL parsing, dispatching steps, and UDF processing

require use of a custom application in C, Java, or some other programming language.

run in priority of account string or by the Teradata dynamic workload management software classification

run in the system priority.

can be placed on a Teradata dynamic workload management software delay queue and can block system resources

do not block.

use AMP Worker Tasks (AWTs)

are not subject to running out of resources (AWTs).