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 using PDM Variables and Macros).

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

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 Creating SQL/XML Queries with the 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.