Chapter 5 Building Triggers and Procedures

Defining templates for stored procedures and functions

Templates for the creation of stored procedures and functions are defined in the current DBMS. You can modify these templates.

Note   Modifying the DBMS
When you modify the templates for stored procedures and functions, you modify the current DBMS. It is recommended that you only edit or modify a copy of a DBMS that is shipped with PowerDesigner.

Steps To define a template for stored procedures or functions:

  1. Select Database→Edit Current DBMS.

    The DBMS property sheet opens to the General page.
  2. Expand the Script node in the DBMS tree view.

    Expand the Objects node.
  3. Expand the Procedure node.
  4. Click the CustomProc entry to edit the stored procedure template.

    or

    Click the CustomFunc entry to edit the function template.

    The Value textbox to the right of the tree view displays the template.
  5. Type changes to the template.
  6. Click OK.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.