LDM to PDM Generation - Using table Alias

[Sybase_novICE]

Hi,

I am used to creating logical models using Oracle Designer. So a
newbie with regards to PowerDesigner.

I want to setup entities with Alias names - 5 letter codes for the
entity. I then want to use the Alias when generating the primary key,
foreign key and index and not the Table Name itself.

So, for example:

Entity Name: Purchase Order
Entity Code: PURCHASE_ORDER
Alias: PUOR

I want to generate the PDM table as:

Table Name: Purchase Order
Table Code: PURCHASE_ORDER
Primary Key Constraint Name: PUOR_PK
Foreign Key (if applicable): PUOR_<Child Table Alias>_FK

Is this possible either via Extended Model Definition or via
Scripting?

Any help or pointers in this matter would be greating appreciated.

Thanks

[Sybase_novICE]

I have progressed a little bit.

I have created an Extended Model Defintion for the LDM and added an
extended attribute to Entity Metaclass. I have called this
EntityAlias.

And I have also figured out that I need to create a Extended Model
Defintion for the PDM and add a Transformation against the Reference
Metaclass (Not sure if its Reference or ReferenceJoin metaclass). But
I don't know how to script it. I have a lot of VB experience, but I am
struggling to finding a scripting guide which lists all the methods
and variables available. Is there any documentation available or
should I use a IDE?

Thanks

Post by Sybase_novICE
Hi,
I am used to creating logical models using Oracle Designer. So a
newbie with regards to PowerDesigner.
I want to setup entities with Alias names - 5 letter codes for the
entity. I then want to use the Alias when generating the primary key,
foreign key and index and not the Table Name itself.
Entity Name: Purchase Order
Entity Code: PURCHASE_ORDER
Alias: PUOR
Table Name: Purchase Order
Table Code: PURCHASE_ORDER
Primary Key Constraint Name: PUOR_PK
Foreign Key (if applicable): PUOR_<Child Table Alias>_FK
Is this possible either via Extended Model Definition or via
Scripting?
Any help or pointers in this matter would be greating appreciated.
Thanks

[Sybase_novICE]

Anyone with any suggestions? Please I am desperate.

Post by Sybase_novICE
I have progressed a little bit.
I have created an Extended Model Defintion for the LDM and added an
extended attribute to Entity Metaclass. I have called this
EntityAlias.
And I have also figured out that I need to create a Extended Model
Defintion for the PDM and add a Transformation against the Reference
Metaclass (Not sure if its Reference or ReferenceJoin metaclass). But
I don't know how to script it. I have a lot of VB experience, but I am
struggling to finding a scripting guide which lists all the methods
and variables available. Is there any documentation available or
should I use a IDE?
Thanks

Post by Sybase_novICE
Hi,
I am used to creating logical models using Oracle Designer. So a
newbie with regards to PowerDesigner.
I want to setup entities with Alias names - 5 letter codes for the
entity. I then want to use the Alias when generating the primary key,
foreign key and index and not the Table Name itself.
Entity Name: Purchase Order
Entity Code: PURCHASE_ORDER
Alias: PUOR
Table Name: Purchase Order
Table Code: PURCHASE_ORDER
Primary Key Constraint Name: PUOR_PK
Foreign Key (if applicable): PUOR_<Child Table Alias>_FK
Is this possible either via Extended Model Definition or via
Scripting?
Any help or pointers in this matter would be greating appreciated.
Thanks- Hide quoted text -

- Show quoted text -

[DM Unseen]

Post by Sybase_novICE
Anyone with any suggestions? Please I am desperate.

Post by Sybase_novICE
I have progressed a little bit.
I have created an Extended Model Defintion for the LDM and added an
extended attribute to Entity Metaclass. I have called this
EntityAlias.
And I have also figured out that I need to create a Extended Model
Defintion for the PDM and add a Transformation against the Reference
Metaclass (Not sure if its Reference or ReferenceJoin metaclass). But
I don't know how to script it. I have a lot of VB experience, but I am
struggling to finding a scripting guide which lists all the methods
and variables available. Is there any documentation available or
should I use a IDE?
Thanks

Post by Sybase_novICE
Hi,
I am used to creating logical models using Oracle Designer. So a
newbie with regards to PowerDesigner.
I want to setup entities with Alias names - 5 letter codes for the
entity. I then want to use the Alias when generating the primary key,
foreign key and index and not the Table Name itself.
Entity Name: Purchase Order
Entity Code: PURCHASE_ORDER
Alias: PUOR
Table Name: Purchase Order
Table Code: PURCHASE_ORDER
Primary Key Constraint Name: PUOR_PK
Foreign Key (if applicable): PUOR_<Child Table Alias>_FK
Is this possible either via Extended Model Definition or via
Scripting?
Any help or pointers in this matter would be greating appreciated.
Thanks- Hide quoted text -

- Show quoted text -- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Normally creating a PDM XEM with exact the same name/code as the LDM
XEM and exact ext attribute names should be enough to get the ext
attributes over from LDM to PDM. No additional stuff is required.

[NewToPD]

I know this was posted a long time ago, but I have exactly the same question. Did you ever find a good answer? I.e. How do you use a LDM Extended Attribute for the PK, AK and FK Index names? We are using PD16.1

Thanks