Chapter 16 Writing SQL Statements in PowerDesigner

Introduction

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:

• The "Building Triggers and Procedures" chapter
• The "Customizing scripts" section in the "Generating a Database from a PDM" chapter

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 "Generation Reference Guide (GTL)" chapter in the Advanced User Documentation .

Copyright (C) 2006. Sybase Inc. All rights reserved.