16.20 - Other Methods of Retrieving Query Band Information - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
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 .