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 .