SQL Code Definition Toolbars

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:


  • Force values to lower-case or upper-case characters

  • Truncate the length of values

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.