SQL Code Definition Toolbars

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.