Function of ViewTable
Captures the DDL for any views used in a query.
ViewTable Table Definition
The following CREATE TABLE request defines ViewTable:
CREATE SET TABLE ViewTable( QueryID INTEGER NOT NULL, ViewName VARCHAR128 CHARACTER SET UNICODE UPPERCASE NOT CASESPECIFIC NOT NULL, DBName VARCHAR128 CHARACTER SET UNICODE UPPERCASE NOT CASESPECIFIC NOT NULL, ViewText VARCHAR(30000) CHARACTER SET UNICODE NOT CASESPECIFIC, SeqNumber BYTEINT NOT NULL, Complete CHAR(1)CHARACTER SET LATIN NOT CASESPECIFIC) PRIMARY INDEX QueryID_ViewName_DBName (QueryID,ViewName,DBName);
Attribute Definitions for ViewTable
The following table defines the ViewTable attributes:
| Attribute | Definition |
|---|---|
| QueryID |
|
| ViewName |
|
| DBName |
|
| ViewText | Stores the DDL view text.
When ViewText > 30,000 characters, only the first 30,000 are stored and the remaining text is stored in overflow rows within ViewTable. The overflow rows are identified by their SeqNumber value. |
| SeqNumber | The sequence of ViewText stored in this row. |
| Complete | Identifies whether ViewTable stores the complete view DDL or a truncated version.
|