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.
Row Values
The following table lists the populated fields in the QryLogParamJSON[V] view.
|
QryLogParamJSON[V] Field |
Description |
|
ParamJSON |
Parameter and data rows in JSON format. |
|
QueryID |
Query ID of the parameterized request. |
|
RowNum |
Row number indicating the sequence of ParamInfo and data record JSON documents. |