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 SQL interfaces for retrieving a query band and parsing the query band string for name and value pairs. The SQL interfaces consist of UDFs and external stored procedures that you can invoke from any application.

Query band external stored procedures run on the PE and can retrieve query bands directly from memory. Query band functions run on the AMPs and require message passing to retrieve the query band. The external stored procedures provide better performance than query band functions.

When issuing query band UDFs, you do not need to fully qualify them by database name. They are automatically searched by the DBS in the SYSLIB database.

When calling query band external stored procedures, you must fully qualify them by the database name, SYSLIB.

For examples of query band functions and external stored procedures, see the following topics.