16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

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
  • CREATE PROFILE
  • MODIFY 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.