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.