16.20 - GetQueryBandValueSP - Teradata Vantage NewSQL Engine

Teradata Vantage™ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

Purpose

Returns the value of the specified name in the current query band.

Definition

REPLACE PROCEDURE SYSLIB.GetQueryBandValueSP
        (IN SearchType SMALLINT,
         IN QBName VARCHAR (129) CHARACTER SET UNICODE,
         OUT QBValue VARCHAR(257) CHARACTER SET UNICODE
        )
               .
               .
               .
;

Input Parameters

Input Parameter Description
SearchType 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 argument.

QBName Name in the query band pair to search for.

Output Parameter

Output Parameter Description
QBValue Value of specified name.

Example: Using GetQueryBandValueSP

CALL SYSLIB.GetQueryBandValueSP(1,'aa',qbval);
 *** Procedure has been executed.
 *** Total elapsed time was 1 second.
QBValue
-------------------------------------
111