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.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
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.