Generating and Reverse-Engineering PDM Extended Objects

Some DBMSs have objects that are not present in the standard PowerDesigner metamodel, and that must be represented as extended objects. PDM extended objects are defined in the Profile category, but their generation and reverse-engineering is controlled by statements and queries defined in the Script/Objects category.

1. Right-click the Script/Objects category, select Add Items, select your new extended object in the list, and then click OK to add it to the list of objects
2. Right-click the new object entry, and select Add Items to add the necessary script items to it. As a minimum, to enable the generation and reverse engineering of the object, you must add the following items:

   • Create

   • Drop

   • AlterStatementList

   • SqlAttrQuery

   • SqlListQuery

3. Click OK to add these script items to your object, and enter the appropriate SQL statements and queries. You will need to enter values for each of these items. For guidance on syntax, see Common Object Items.
4. [optional] To control the order in which this and other objects will be generated, use the Generation Order item (see Script/Objects Category (DBMS)).