GetQueryBandPairs 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

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

REPLACE FUNCTION SYSLIB.GetQueryBandPairs (
  SearchType SMALLINT
) RETURNS TABLE (
    QBName  VARCHAR(129) CHARACTER SET UNICODE,
    QBValue VARCHAR(257) CHARACTER SET UNICODE
  )
  ...
;
REPLACE FUNCTION SYSLIB.GetQueryBandPairs (
  QueryBandIn  TD_ANYTYPE,
  SearchType   SMALLINT
) RETURNS TABLE (
    QBName  VARCHAR(129) CHARACTER SET UNICODE,
    QBValue VARCHAR(257) CHARACTER SET UNICODE
  )
  ...
;

Syntax Elements

SearchType
Search type:
  • 0 = Return the name-value pairs in both transaction and session query bands are returned.

    If the same name occurs in both the transaction and the session query bands, the value for the transaction query band is returned.

  • 1 = Return only the name-value pairs in the transaction query band.
  • 2 = Return only the name-value pairs in the session query band.
  • 3 = Return only the name-value pairs in the profile query band.
QueryBandIn
Query band string.
QBName
Name of the query band.
QBValue
Value of the query band.