Category: Query
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | Returns the process ID of the dispatcher. |
CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | (Prime Key) Time and date when the DBQL objects cache was written. |
QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | Returns a system-wide unique ID to identify the query. |
ObjectDatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Name of the database that owns the target object. |
ObjectTableName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of table or view. |
ObjectColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the column. If the object type is I or Index, the system returns the name of the column associated with the index. |
ObjectID | BYTE(4) NOT NULL | X(8) | Returns the internal ID of the object. |
ObjectNum | INTEGER | --,---,---,--9 | Used for indexes or columns. |
ObjectType | CHAR(3) LATIN NOT CASESPECIFIC NOT NULL | X(3) | DB-Database, Tab-Table, Col-Column, Idx-Index, Mac-Macro, Viw-View, etc. |
FreqofUse | INTEGER | --,---,---,--9 | Returns the count of the number of optimizer references to the object from the parse tree. |
TypeOfUse | VARCHAR(46) UNICODE NOT CASESPECIFIC | X(46) | Returns the use of the object. |