GetQueryBandValue Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248

The GetQueryBandValue functions are two overloaded functions. One requires the query band string to be passed in; the other uses internal calls to retrieve the query band.

REPLACE FUNCTION SYSLIB.GetQueryBandValue (
  SearchType SMALLINT,
  QBName     TD_ANYTYPE
) RETURNS VARCHAR (257)CHARACTER SET UNICODE
  ...
;

REPLACE FUNCTION SYSLIB.GetQueryBandValue (
  QueryBandIn TD_ANYTYPE,
  SearchType  SMALLINT,
  QBName      TD_ANYTYPE
) RETURNS VARCHAR (257)CHARACTER SET UNICODE
  ...
;

Syntax Elements

SearchType
Search type:
  • 0 = Return the value of the first name-value pair where name is specified by the QBName input argument.

    If the query band contains the name-value pairs for the transaction and session, the function searches the transaction name-value pairs first.

  • 1= Search the transaction name-value pairs in the query band and return the value that corresponds to the name specified by the QBName input parameter.
  • 2 = Search the session name-value pairs in the query band and return the value that corresponds to the name specified by the QBName input parameter.
  • 3 = Search the profile name-value pairs in the query band and return the value that corresponds to the name specified by the QBName input parameter.
QBName
Name in the query band pair to search for.
QueryBandIn
A query band string or NULL.