Use of Query Bands | SET QUERY_BAND | Teradata Vantage - 17.10 - Query Bands and External Routines - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

External routines can access the query band information for both sessions and transactions. External routine is the generic term to describe external procedures, UDFs, and user-defined methods.

For example, SQL procedures can make SQL requests to set the query band of the transaction using a SET QUERY_BAND request. An SQL procedure can also retrieve the current query band using the QUERY_BAND built-in function.

An external procedure can set the transaction query band by calling an SQL procedure. You can also use an FNC call to retrieve the query band or to get the value of a name within it.

Note that there is no FNC interface to set a query band (see Teradata Vantage™ - SQL External Routine Programming, B035-1147 for details).