Writing SQL using 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 using 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 Customizing Generation with GTL chapter of the Customizing and Extending PowerDesigner manual.