16.10 - Row Values - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
April 2018
Content Type
Publication ID
English (United States)
Last Update

The following table describes the fields in a DBQLParamTbl row.

DBC.DBQLParamTbl field Description
CollectTimeStamp Time the query log was generated.
ParamInfo Name, type, position, and value for each parameter in the parameterized request.

Where the parameter marker or positional parameter is “?” in the request, DBQL replaces the variable names with system-generated names P1 to P n. The numbering 1 to nstands for the parameter positions from left to right as they appear in the request text.

ProcID ID of the processor that handled the request being logged.
QueryID Query ID of the parameterized request.
ZoneID Reserved for future use.

The TD_DBQLParam embedded services function converts the contents of the BLOB type ParamInfo column into JavaScript Object Notation (JSON) format for use in diagnosing parameterized query problems.