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.