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.

1. Select Database > Edit Current DBMS to open the DBMS definition file in the resource editor, and then click the Procedure Templates tab:
   
   
   
2. Click the Add a Row tool to add a new blank template to the list.
3. Type a new name and code for the new template and click Apply to commit its creation.
4. Click the Properties tool to open the property sheet of the new procedure template:
   
   
   
5. Click the Definition tab and enter or modify the definition code. You can use PDM variables and macros and various other tools available from the toolbar (see SQL Editor Tools).
6. You can also modify other of the procedure template's properties. For a full list of the properties available, see Procedure Template Properties.
7. Click OK in each of the dialog boxes.

   A confirmation box will appear, asking if you want to save the changes to the DBMS.

   Click Yes to confirm the template creation.