TD_DBQLFUL | SQL Operators & User-Defined Functions | Teradata Vantage - 17.10 - TD_DBQLFUL - 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 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.