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. |