Writing SQL using PDM Variables and Macros

You can use PDM variables and macros to write SQL statements.

In the following example, a trigger written using the PDM variables and macros is attached to the Example table, and writes the contents of any insertion to HistoryTable.

See Writing SQL using GTL for an example of the same trigger written using the PowerDesigner GTL:

The actual trigger code can be viewed on the Preview tab:

For lists of the available variables and macros, see PDM Macros, PDM Variables, and PowerDesigner Formatting Variables.

• PDM Variables
  Many objects have both a code variable and a generated code variable.
• Formatting Variables
  You can control the case, length, quoting, and other aspects of the format of values resolved from variables
• PDM Macros
  You can use predefined macros in trigger templates, template items, triggers, and procedures. Macros perform specific functions.