Creating Models › Target Servers for Physical Models › Database Property Editors › Materialized Query Tables › Materialized Query Column › Add a Materialized Query Column Expression in the Materialized Query Tables Editor

Add a Materialized Query Column Expression in the Materialized Query Tables Editor

You can use the Materialized Query Tables editor to add a materialize query column expression.

To add a materialized query column expression in the materialized query tables editor

1. In a physical model based on DB2, right-click a materialized query table, and select Materialized Query Table Properties.

   The Materialized Query Tables dialog opens.

2. Click the Select tab, then in the lower section of the dialog, click New.

   The New Materialized Query Table Column dialog opens.

3. Complete the following fields:

   Name/Alias

   Defines the name of the materialized query column expression.

   Expression

   Defines the expression text.

   Note: Click Cancel to close the dialog without saving your changes.

4. Click OK to add the New materialized query column.

   You are returned to the Materialized Query Table editor.