The following table lists the populated fields in a DBQLSQLTbl row.
|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.