Chapter 16 Writing SQL Statements in PowerDesigner

Writing SQL with the PowerDesigner GTL

You can use the PowerDesigner Generation Template Language (GTL) to write SQL statements.

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

See "Writing SQL with the PDM Variables and Macros" for an example of the same trigger written using the PowerDesigner macros and variables:

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

For more information, see the "Generation Reference Guide (GTL)" chapter in the Advanced User Documentation .