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.