16.10 - Row Values - Teradata Database

Teradata Database Administration

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

The following table lists the populated fields in a DBQLSQLTbl row.

DBC.DBQLSQLTbl Field Description
CollectTimeStamp Time that the rows were written to the database. This field is also part of the multi-column NUPI (see also ProcID).

For more information on CollectTimeStamp, see Comparing CollectTimeStamp Value Between Tables.

ProcID Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).
QueryID Internally generated identifier of the query.
QueryID is a system-wide unique field; You can use QueryID to join DBQL tables or the DBC.TdwmExceptionLog table with DBQL tables without needing ProcID as an additional join field.
SQLRowNo Row number of the statement. Value is 1 unless the statement is large and requires multiple rows.
SQLTextInfo A full SQL text segment, a string of up to approximately 32,000 characters.
BTEQ has a limited column length. Use Teradata Studio to display longer lengths.
If SQLTextInfo has more than one row per QueryID, use the QryLogSQLDoc[V] view to see a single, readable document per QueryID. For more information, see Improving SQL Text Readability.