GetQueryBandValueSF Syntax - Teradata Vantage

The GetQueryBandValueSF 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.

CREATE FUNCTION TD_SYSFNLIB.GetQueryBandValueSF (
  QueryBandIn TD_ANYTYPE,
  SearchType  SMALLINT,
  QBName      TD_ANYTYPE
) RETURNS VARCHAR(257) CHARACTER SET UNICODE
...
;

CREATE FUNCTION TD_SYSFNLIB.GetQueryBandValueSF (
  SearchType  SMALLINT,
  QBName      TD_ANYTYPE
) RETURNS VARCHAR(257) CHARACTER SET UNICODE
...
;

Syntax Elements

QueryBandIn

A query band string or NULL.

SearchType

A numeric argument specifying which query band type to search for the name:

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

  If the query band contains 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 argument.
• 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 argument.
• 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. The function returns the value in the name-value pair. A query band name is a maximum of 128 characters.