16.10 - View of the Parameterized Query Log Table: QryLogParamJSON[V] - Teradata Database

The QryLogParamJSON[V] view is populated if parameterized request logging is enabled with the PARAMINFO option for BEGIN/REPLACE QUERY LOGGING and this view (QryLogParamJSON[V]) is included in a request.

For example:

SELECT QueryID, RowNum, ParamJSON from QryLogParamJSON;

converts all the rows in DBQLParamTbl to JSON documents. With this view, users can perform JSON operations on the ParamJSON column data.