Defining a Generation Order for Views

You can define the order of the generation of views by using traceability links with a type of DBCreateAfter. The view from which you start the traceability link is dependent on the view you link it to, and this influent view will be generated before the dependent view.

Context

For example you create the view DEPARTMENT STORE from the table STORE, and then another view called COMPUTER COUNTER from the view DEPARTMENT STORE to show only part of the department store offer.

By default, views are generated in alphabetical order, so the generation of COMPUTER COUNTER will fail since the view DEPARTMENT STORE on which it depends is not yet generated. To bypass this problem, you should create a traceability link of type <<DBCreateAfter>> from COMPUTER COUNTER to DEPARTMENT STORE to ensure that DEPARTMENT STORE is generated before COMPUTER COUNTER:

Note There is a model check to warn you if you create a reflexive or circular set of traceability links of type DBCreateAfter. If you generate without correcting this error, views will be generated in alphabetical order, without taking into account the generation order.

1. Select the Traceability Links tool in the toolbox.
2. Click inside the dependent view and, while holding down the mouse button, drag the cursor into the influent view. Release the mouse button.
3. Double-click the traceability link to open the property sheet of the dependent object at the Traceability Links tab.

   The influent view is displayed in the Linked Object column.

4. Click in the Link Type column, click the down arrow and select DBCreateAfter.
   
   
   
5. Click OK to close the property sheet and return to your model.
   Note You can, alternatively, create DBCreateAfter traceability links directly on the Traceability Links tab (see Defining a Generation Order for Stored Procedures). For detailed information about traceability links, see Core Features Guide > Modeling with PowerDesigner > Objects > Traceability Links.