17.05 - Open APIs (SQL Interfaces) - 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

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.