16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

This view provides access to parameter and metadata information in Teradata JSON UDT type.

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

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.

For more information about this option, see Teradata® Vantage SQL Data Definition Language Syntax and Examples, B035-1144.

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 Teradata® Vantage SQL Support for Database Administration, 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 in Teradata JSON UDT type. For more information about this TD_SYSFNLIB.TD_DBQLParam table operator function, see Teradata® Vantage SQL Support for Database Administration, B035-1210.