You can use the User Defined SQL tab in the Materialized Query Tables editor to view and change the SQL code that is maintained for a materialized query table.
You should create user-defined SQL only if you want the materialized query table to contain syntax that CA ERwin Data Modeler cannot represent, such as a complex JOIN statement. When you create user-defined SQL, CA ERwin Data Modeler no longer maintains references to the base tables and columns to which the materialized query table refers, and any relationships to source tables in the model are no longer maintained.
To create user-defined sql code for a materialized query table
The Materialized Query Table Editor opens.
Your changes are saved and the Materialized Query Table Editor closes.
Note: Click Cancel to close the dialog without saving your changes.
Copyright © 2013 CA.
All rights reserved.
|
|