This interface can be called by a UDF, UDM, or external stored procedure to retrieve the current query band, a string of name-value pairs that can be set on a session, transaction, or profile to identify the originating source of queries and help manage task priorities and track system use.
IF you want to … | THEN use the … |
---|---|
set the query band for a session or transaction | SET QUERY_BAND SQL statement. For details, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144. |
add or modify a query band for a profile |
For details, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144. |
get transaction, session, or profile name-value pairs from the query band string that FNC_GetQueryBandU returns | FNC_GetQueryBandPairsU function. For details, see FNC_GetQueryBandPairsU. |
search the transaction, session, or profile name-value pairs in the query band string that FNC_GetQueryBandU returns and get the value that corresponds to a specific name | FNC_GetQueryBandValueU function. For details, see FNC_GetQueryBandValueU. |