getQueryBandValue(String QBandBuf, int QB_SearchType, String QBName) - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

Search the transaction, session, and/or profile name-value pairs in the query band string pointed to by the QBandBuf input argument and retrieve the value for a specified name.

Arguments

Argument Description
QBandBuf A query band string, where the query band can be:
  • Returned by QueryBand.getQueryBand()
  • Retrieved from the DBC.DBQLogTbl.QueryBand column
  • Specified by the caller
QB_SearchType Specifies whether getQueryBandValue() searches for name-value pairs in the transaction, session, and/or profile query band.
If the value is...
  • QueryBand.QB_FIRST, then return the value of the first name-value pair, where the name is specified by the QBName input argument. If the query band string contains name-value pairs for the transaction, session, and profile, getQueryBandValue() searches the name-value pairs in the following order:
    • Transaction query band
    • Session query band
    • Profile query band
  • QueryBand.QB_TXN, then search the transaction name-value pairs in the query band and return the value that corresponds to the name specified by the QBName input argument.
  • QueryBand.QB_SESSION, then search the session name-value pairs in the query band and return the value that corresponds to the name specified by the QBName input argument.
  • QueryBand.QB_PROFILE, then search the profile name-value pairs in the query band and return the value that corresponds to the name specified by the QBName input argument.
QBName The name in the name-value pair to return the value for.