Trigger Template Items (PDM)

Trigger template items are named reusable blocks of script that can be inserted into trigger templates or triggers.

In a generated trigger script, a template item calls a macro that implements a trigger referential integrity constraint or does any other updating work on tables in the database.

.FOREACH_PARENT()
/*  Parent "[%PQUALIFIER%]%PARENT%" must exist when inserting a child in "[%CQUALIFIER%]%CHILD%"  */
if (.JOIN("new_ins.%FK% is not null", "", " and", ") then")
begin
 set found = 0;
 select 1
  into  found
  from  dummy
 where  exists (select 1
       from  [%PQUALIFIER%]%PARENT%
      where  .JOIN("%PK% = new_ins.%FK%", "and ", "", ");")
 if found <> 1 then
  message 'Error: Trigger(%TRIGGER%) of table [%QUALIFIER%]%TABLE%';
  message '    Parent code must exist when inserting a child!';
  signal user_defined_exception;
 end if;
end
end if;
.ENDFOR

• Creating a Trigger Template Item
  You usually create a template item when an existing template item is not suitable, or to create a repeatable block of code to do updating work on tables in the database.
• PowerDesigner Pre-defined Trigger Template Items
  PowerDesigner ships pre-defined template items for each pre-defined trigger template defined in the supported DBMS. The Rebuild Triggers function uses both pre-defined and user-defined trigger templates to automatically create triggers for selected tables.
• Modifying a Trigger Template Item
  You can modify both your template items and those that are provided with PowerDesigner.
• Trigger Template Item Properties
  To view or edit a trigger template item's properties, double-click its entry in the Browser, in the List of User-Defined Trigger Template Items or in the DBMS Properties window. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.