16.10 - View of the Parameterized Query Log Table: QryLogParam - Teradata Database

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

For example:

SELECT QueryID, RowNum, ParamJSON from QryLogParam;

converts all the rows in DBQLParamTbl to JSON documents. The output is in CLOB format. To perform JSON operations on the data, use the QryLogParamJSON view instead.