SQL Editor Tools

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 (see Writing SQL Statements in PowerDesigner).

Variables - Lists variables for use with operators and functions for insertion in the trigger definition (see PDM Variables). You can also use formatting variables to force values to lower-case or upper-case or to truncate the length of values characters, as follows (see Formatting Variables).

Edit with SQL Editor - [object property sheet tabs only] Opens the standalone SQL Editor dialog which 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. The XML model must be open in the workspace and have the SQL/XML extension file attached. Inserts a SQL/XML macro referencing the selected element in the trigger definition.