Chapter 5 Building Triggers and Procedures
When you write a stored procedure, PowerDesigner automatically creates dependencies to any table, view, procedure, or database package referenced in the procedure. These dependencies are taken into account when performing an impact analysis prior to deleting the procedure or an object on which it depends. If the procedure has a symbol in your diagram, then any dependencies will be shown graphically by way of arrows linking the procedure to these objects.
The diagram below shows a procedure, Proc_Change_Location, which is dependent on a number of other objects:
The Extended Dependencies tab of the procedure property sheet lists the objects upon which the procedure depends. The stereotype "DBCreateAfter" specifies that the procedure can only be built after these objects.
The Dependencies tab of the Employee table property sheet shows that Proc_Change_Location is dependent upon it.
If you were to perform an impact analysis prior to deleting the Employee table, you would be warned of the dependency of the procedure upon it.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |