Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantage™

This view contains confidential user information and should be accessed only by trusted data personnel with access to the restrictive user DBC password. For more information about the user DBC password, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.

The QryLogParamV view is populated if parameterized request logging is enabled with the PARAMINFO option for BEGIN/REPLACE QUERY LOGGING and this view (QryLogParamV)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.

For more information, see Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.

RowNum

This column is generated by the TD_SYSFNLIB.TD_DBQLParam table operator function at runtime. For more information about this function, see Teradata Vantage™ SQL Operators and User-Defined Functions, B035-1210.

ParamJSON

This column is generated by the TD_SYSFNLIB.TD_DBQLParam table operator function at runtime. This column converts the parameter values and metadata logged to the DBC.DBQLParamTbl.ParamInfo table column into JSON format. For more information about this TD_SYSFNLIB.TD_DBQLParam table operator function, see Teradata Vantage™ SQL Operators and User-Defined Functions, B035-1210.