Writing SQL Statements in PowerDesigner

PowerDesigner allows you to associate your own custom SQL statements with many database objects.

You can write triggers and procedures, and also add begin and end scripts to many database objects.

For more information, see:

Instead of hard coding the names of tables, columns, and other objects in your SQL statements, you can use the PowerDesigner Generation Template Language (GTL) or the PDM variables and macros to obtain these values from the model.

While you can perform many tasks using the PDM variables and macros, the GTL is more powerful, as it allows you to access any information about any object in the model.

For more detailed information about the GTL, see the Customizing Generation with GTL chapter of the Customizing and Extending PowerDesigner manual.

• Writing SQL with the PowerDesigner GTL
  You can use the PowerDesigner Generation Template Language (GTL) to write SQL statements.
• Writing SQL with the PDM Variables and Macros
  You can use the PDM Variables and Macros to write SQL statements.
• PDM Macros
  You can use predefined macros in trigger templates, template items, triggers, and procedures. Macros perform specific functions.
• PDM Variables
  Many objects have both a code variable and a generated code variable.
• PowerDesigner Formatting Variables
  Variables have a syntax that can force a format on their values, as follows:

---

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com