17.10 - Other Methods of Retrieving Query Band Information - 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)

Teradata supplies equivalent CLIv2 and SQL interfaces to return the query band for a specified session.

Interface Command or Function Name
CLIv2 MONITOR QUERYBAND
SQL MonitorQueryBand

The MONITOR QUERYBAND PM/API interface is fully documented in Teradata Vantage™ - Application Programming Reference, B035-1090.

Teradata also supplies three library functions to enable UDFs, methods, and external procedures to retrieve query band names, query band values, or query band name:value pairs.

To return this value from the current query band … Use this library function …
name FNC_GetQueryBand
value FNC_GetQueryBandValue
all name:value pairs FNC_GetQueryBandPairs

For more information, see Teradata Vantage™ - SQL External Routine Programming, B035-1147.