Instead of modeling each individual database package by hand, you can use a template and have PowerDesigner generate packages specific to each table. Database packages defined through a template are updated automatically when you make changes to the table definition, and you can quickly create packages for multiple tables from the Rebuild Table Database Packages dialog.
Database package templates are written in the PowerDesigner Generation Template Language (GTL). PowerDesigner provides a template for generating CRUD procedures, and you can create your own templates as necessary.
To define a database package from a template, simply select the template on the General tab of the database package property sheet.
The available database package templates are defined in the DBMS resource file. Select , click the Database Package Templates tab. To create a database package template, click the Add a Row tool
To open a template property sheet, select it in the list and click the Properties tool.
The General tab contains the following properties:
|
Property |
Description |
|---|---|
|
Name |
The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users. |
|
Code |
The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces. |
|
Comment |
Provides a description of the template. |
|
DBMS |
Specifies the DBMS version. |