17.10 - Output - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

The following help statement provides detailed description of the function argument and output parameters.

help function TD_SYSFNLIB.TD_DBQLFUL;
Column Data Type Description
QID DECIMAL(18,0) Input parameter QueryID from DBC.DBQLogTbl.QueryID.
Data VARBYTE Input parameter VARBYTE data from DBC.DBQLogTbl.FeatureUsage.
QueryID DECIMAL(18,0) Output table column #1 (Foreign Key) System wide unique value to join DBQL tables.
FeatureUsageJSON JSON Output table column #2 feature list in JSON format.