TD_DBQLFUL | SQL Operators & User-Defined Functions | Teradata Vantage - TD_DBQLFUL - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
fsi1592016213432.ditamap
dita:ditavalPath
fsi1592016213432.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

The FeatureUsage column stores usage information in binary format. You can use the TD_SYSFNLIB.TD_DBQLFUL table function to convert the binary data into a JSON document. To display feature use information in JSON format, access the FeatureInfo column of the DBC.QryLogFeatureJSON view.

TD_DBQLFUL is an embedded services system function.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Result Type

TD_SYSFNLIB.TD_DBQLFUL returns a JSON type document as an array of features. For example, if a request used five features, the resulting JSON document has a descriptive name for each of the five features in an array format.

Syntax

[TD_SYSFNLIB.] TD_DBQLFUL ( QueryID
  Decimal(18.0)_type_column,
   VARBYTE_type_column
)

Syntax Elements

TD_SYSFNLIB.
Name of the database where the function is located.
QueryID
The QueryID column in the table DBC.DBQLogTbl.