identity property with integer rather than numeric

[rdumont]

i'm generating a pdm from a cdm using PD 15.2 for a sql server 2008
platform. The only auto increment data type option I see in CDM is the
serial option which then creates a numeric column in the PDM with an
identity property. How can I get it to generate an integer column with
identity property?

I managed to embed the identity property in the CDM data type but then
when my foreign keys are created in the PDM they too have the identity
property which I do not want.

[gtss]

In my DBMS resource details, for the internal data type Serial (NO) I
changed the physical data type from 'numeric' to 'integer'.

In PD 15.2:
Go to menu Tools / Resources / DBMS... then choose your DBMS
definition and open it (double-click or click Properties).
Then go to Script / DataType / AmcdDataType.
Select the row in which Internal = NO. Change the value in the
Physical Model column in the same row from 'numeric' to 'integer'.
That's it.

Post by rdumont
i'm generating a pdm from a cdm using PD 15.2 for a sql server 2008
platform. The only auto increment data type option I see in CDM is the
serial option which then creates a numeric column in the PDM with an
identity property. How can I get it to generate an integer column with
identity property?
I managed to embed the identity property in the CDM data type but then
when my foreign keys are created in the PDM they too have the identity
property which I do not want.

[gtss]

Forgot to mention, for completeness: at the end, save the DBMS
resource bundle with a different name, so that you don't disturb the
original provided by PD.
After you make the change to Physical Model to 'integer' and click OK,
you're back to the main view of the DBMS definition. There is a floppy
disk icon in the right top corner, where you can choose Save or Save
As. Better use Save As.

Post by gtss
In my DBMS resource details, for the internal data type Serial (NO) I
changed the physical data type from 'numeric' to 'integer'.
Go to menu Tools / Resources / DBMS... then choose your DBMS
definition and open it (double-click or click Properties).
Then go to Script / DataType / AmcdDataType.
Select the row in which Internal = NO. Change the value in the
Physical Model column in the same row from 'numeric' to 'integer'.
That's it.

Post by rdumont
i'm generating a pdm from a cdm using PD 15.2 for a sql server 2008
platform. The only auto increment data type option I see in CDM is the
serial option which then creates a numeric column in the PDM with an
identity property. How can I get it to generate an integer column with
identity property?
I managed to embed the identity property in the CDM data type but then
when my foreign keys are created in the PDM they too have the identity
property which I do not want.