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

Teradata Vantageā„¢ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

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.