17.10 - 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
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
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.