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

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.

Row Values

The following table lists the populated fields in the QryLogParam[V] view.

 

QryLogParam[V] Field

Description

ParamJSON

Parameter and data rows in CLOB format.

QueryID

Query ID of the parameterized request.

RowNum

Row number indicating the sequence of ParamInfo and data record JSON documents.