16.20 - System Routines that Use FNC_GetQueryBandValue - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Teradata provides a UDF called GetQueryBandValue and an external stored procedure called GetQueryBandValueSP that use FNC_GetQueryBandValue to search the transaction, session, and/or profile name-value pairs in the query band and retrieve the value for a specified name. GetQueryBandValue and GetQueryBandValueSP are created in the SYSLIB database when you execute the DIPDEM script using the DIP utility.

For more information on DIP, see Teradata Vantage™ - Database Utilities , B035-1102 . For more information on GetQueryBandValue and GetQueryBandValueSP, see Teradata Vantage™ - Application Programming Reference, B035-1090.