Query Bands and External Routines | VantageCloud Lake - Query Bands and External Routines - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

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

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.

There is no FNC interface to set a query band.