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.



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



For detailed information about working with GTL, see Customizing and Extending PowerDesigner > Customizing Generation with GTL .

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