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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.