MQT properties

Properties for IBM® data server MQT objects

For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Schema Shows the relational schema under which this object was created.
Refresh Specifies an option for the REFRESH clause. You can select IMMEDIATE or DEFERRED. An MQT that is REFRESH DEFERRED will not reflect changes to the underlying base tables until a REFRESH TABLE statement is issued.
Optimize query Select to specify the ENABLE QUERY OPTIMIZATION option.
Maintained by Specifies an option for the MAINTAINED BY clause. You can select SYSTEM or USER.
Columns page
Property Description
Name Shows the name of the columns that make up the MQT.
Data Types Shows the data types of the columns that make up the MQT.
SQL page
Property Description
Expression Specifies an SQL expression for the MQT.
Validate Validates the SQL expression in the Expression field.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback