Procedure Templates (PDM)

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

PowerDesigner provides certain basic procedure templates for those databases that support them, which create procedures linked to tables. You can modify the code of these pre-defined templates, but they cannot be deleted or renamed:

Template type	Generates procedure executing...
`DeleteProcedure`	a SQL Delete statement
`InsertProcedure`	a SQL Insert statement
`SelectProcedure`	a SQL Select statement
`UpdateProcedure`	a SQL Update statement

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.
Modifying a Procedure Template
You can modify both your templates and those that are provided with PowerDesigner.
Procedure Template Properties
To view or edit a procedure template's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

Parent topic: Triggers and Procedures