17.05 - Embedded Services System API Features - Teradata Database

Teradata Vantage™ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

Functionality

Embedded services system APIs follow the implicit data type conversion rules that apply to UDFs. For more information about the implicit data type conversion rules, see Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145.

The following table describes the different embedded services system interfaces.

If you want to ... Use the following SQL interface ...
return the current type of Priority Scheduler being used (for example, workload definitions) GetPSFVersion.
retrieve the maximum CPU and I/O capacity on demand (COD) values from the Priority Scheduler TD_get_COD_limits.
return the value of the specified name in the current query band or NULL GetQueryBandValueSF.