Chapter 16 Writing SQL Statements in PowerDesigner

Writing SQL with the PDM Variables and Macros

You can use the 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 with the PowerDesigner 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".