Trigger, procedure and template property sheet Definition tabs provide tools to help writing SQL code.
Tool |
Description |
---|---|
|
Add Trigger Item From Model - [Triggers and trigger templates only] Opens a dialog box to select a trigger template item defined in the model for insertion in the trigger definition. |
|
Add Trigger Item From DBMS - [Triggers and trigger templates only] Opens a dialog box to select a trigger template item defined in the DBMS definition file for insertion in the trigger definition. |
|
Operators - Lists logical operators for insertion in the trigger definition. |
|
Functions - Lists group, number, string, date, conversion and other functions for insertion in the trigger definition. |
|
Macros - Lists macros for insertion in the trigger definition. For more information on macros, see Writing SQL Statements in PowerDesigner. |
|
Variables - Lists variables for use with operators and functions for insertion in the trigger definition. You can also use formatting variables that have a syntax that can force a format on their values, as follows: For more information on variables, see PDM Variables. |
|
Edit with SQL Editor - Opens the SQL Editor dialog box. Provides object types and available objects for insertion in the trigger definition. |
|
SQL/XML Wizard - Opens the SQL/XML Wizard to build a SQL/XML query from a table or a view and insert it in the trigger definition (see Using the SQL/XML Wizard). |
|
Insert SQL/XML Macro - Opens a dialog box to select a global element in an XML model open in the workspace with the SQL/XML extended model definition. Inserts a SQL/XML macro referencing the selected element in the trigger definition. |