15.00 - Other Methods of Retrieving Query Band Information - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Other Methods of Retrieving Query Band Information

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 Application Programming Reference.

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

See SQL External Routine Programming for details.