This view contains confidential user information and must be accessed only by trusted personnel with access to the restrictive user DBC password.
The QryLogParamJSON view is populated if parameterized request logging is enabled with the PARAMINFO option for BEGIN/REPLACE QUERY LOGGING and this view (QryLogParamJSON) 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.
RowNum
This column exists only in the QryLogParamJSON view, which is generated by the TD_SYSFNLIB.TD_DBQLParam table operator function at runtime. For more information about this function, see TD_DBQLParam .
ParamJSON
This column is generated by the TD_SYSFNLIB.TD_DBQLParam table operator function at runtime. For more information about this TD_SYSFNLIB.TD_DBQLParam table operator function, see TD_DBQLParam .