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.
|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.|
|SqlTextDoc||Combines multiple SQLTextInfo rows with the same QueryID into a single XML document as CLOB type.|