. DATATYPE: Integer. |
| Name of the DB2 UDB Materialized Query Table. DATATYPE: String. |
| Owner of the DB2 UDB Materialized Query Table. DATATYPE: String. |
| True if query optimization is enabled, otherwise it is false. DATATYPE: String. |
| Tells whether the DB2 UDB Materialized Query Table is refreshable. DATATYPE: Boolean. |
| True if the refresh is immediate, and false if it is deferred. DATATYPE: Boolean. |
| Select statement of the DB2 UDB Materialized Query Table. DATATYPE: String. |
| Tablespace of the DB2 UDB Materialized Query Table. DATATYPE: String. |