Building Triggers and Procedures

PowerDesigner provides support for modeling triggers and stored procedures.

• Triggers (PDM)
  A trigger is a segment of SQL code associated with a table or a view, which is invoked automatically whenever there is an attempt to modify data in the associated table or view with an insert, delete, or update command.
• DBMS Triggers (PDM)
  A DBMS trigger is not associated with any table or view, and fires on modifications to the database structure itself, such as the creation or dropping of a table or events like startup, shutdown, login etc.
• Trigger Templates (PDM)
  PowerDesigner trigger templates and template items allow you to create triggers in a modular reusable fashion.
• Trigger Template Items (PDM)
  Trigger template items are named reusable blocks of script that can be inserted into trigger templates or triggers.
• Stored Procedures and Functions (PDM)
  You can define stored procedures and functions for any DBMS that supports them.
• Procedure Templates (PDM)
  PowerDesigner procedure templates allow you to create procedures in a modular reusable fashion.
• SQL Code Definition Toolbars
  The following tools are available on the Definition tabs of trigger, procedure and template property sheets:
• Creating SQL/XML Queries with the Wizard
  You can use the SQL/XML Wizard to insert a SQL/XML query in the definition of a trigger, stored procedure, or function to store or retrieve data, in an XML format, from relational databases supporting SQL/XML. The wizard, allows you to select tables and views from a PDM to build a mapped XML model. This XML model (which does not appear in the workspace) is used to generate SQL/XML queries from global elements.
• Generating Triggers and Procedures
  You can create or modify database triggers to a script or to a live database connection.

---

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com