Procedure Templates (PDM)

PowerDesigner procedure templates allow you to create procedures in a modular reusable fashion.

PowerDesigner provides certain basic procedure templates and also allows you to write your own. You can create procedure templates in your DBMS definition file or in your model. These elements will be available as follows:

Procedure template created in:	Available to
DBMS (shared definition file)	All models sharing the DBMS
DBMS (copied definition file)	Current model only

For more information on the DBMS share and copied definition files, see Generating a Database from a PDM.

Note:

By modifying a DBMS template, you modify its definition in the current DBMS. You should only modify a DBMS if you have already made a copy of the DBMS definition file provided with PowerDesigner.

For more information on working with DBMS resource files, see the DBMS Resource File Reference chapter of the Customizing and Extending PowerDesigner manual.

Creating a Procedure Template
You can create a new procedure template in your DBMS definition file or as part of your model. You can begin by copying an existing template or write one from scratch:
PowerDesigner Pre-defined Procedure Templates
The pre-defined DBMS templates provided with PowerDesigner generate SQL insert, delete, update, and select statement procedures.
Modifying a Procedure Template
You can modify both your templates and those that are provided with PowerDesigner.
Procedure Template Properties
You can modify a procedure template's properties from its property sheet. The following sections detail the property sheet tabs that contain the properties most commonly entered for procedure templates.

Parent topic: Building Triggers and Procedures