The QryLogSQLDoc[V] view is populated if you request that SQL is shown for a query along with the default information. The WITH SQL option causes DBQL to attempt to log the full statement text, no matter how large, into the DBQLSQLTbl table.
QryLogSQLDoc[V] combines multiple rows of SQLTextInfo with the same QueryID into a single SQLTextDoc document. The following table lists the populated fields in the QryLogSQLDoc[V] view.
|
QryLogSQLDoc[V] 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” on page 380. |
|
ProcID |
Unique processor ID of the Dispatcher and part of the multi-column NUPI (also see CollectTimeStamp). |
|
QueryID |
Internally generated identifier of the query. |
|
SqlTextDoc |
Combines multiple SQLTextInfo rows with the same QueryID into a single XML document as CLOB type. |