Materialized query tables are supported for IBM DB2 for z/OS 10 and higher. PowerDesigner models materialized query tables as views with a stereotype of <<Materialized query table>>.
You can create a materialized query table in any of the following ways:
Select to access the List of Materialized Query Tables, and click the Add a Row tool.
Right-click the model (or a package) in the Browser, and select .
You can modify an object's properties from its property sheet. To open a materialized query table property sheet, double-click its diagram symbol or its Browser entry in the Materialized Query Tables folder.
The following extensions are available on the General tab:
Name |
Description |
|---|---|
Result table |
Specifies whether the materialized view is a query table or result table. Scripting name: WithNoData |
Maintained by |
[Query table] Specifies how the data in the materialized query table is maintained. Scripting name: MaintainedBy |
Query optimization |
[Query table] Specifies whether this materialized query table can be used for optimization. Scripting name: QueryOptimization |
Column default |
[Result table] Specifies whether or not to copy column defaults. Scripting name: ColumnDefault |
Identity |
[Result table] Specifies whether or not to copy identity column attributes. Scripting name: Identity |
The following tabs are also available: