Chapter 6 Building Triggers and Procedures

SQL Code Definition Toolbars

The following tools are available on the Definition tabs of trigger, procedure and template property sheets:

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 the "Writing SQL Statements in PowerDesigner" appendix.

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 List of PowerDesigner variables in chapter Variables in PowerDesigner.

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. For more information on the SQL/XML Wizard, 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.

For more information on macros and variables, see the "Writing SQL Statements in PowerDesigner" appendix.

For more information on the SQL/XML Wizard, see Using the SQL/XML Wizard.

 

Copyright (C) 2006. Sybase Inc. All rights reserved.