using erwin to generate db2 ddl scripts

[ddiamond]

I used erwin to generate db2 ddl scripts. The only problem I ran into is that erwin is generating nameless foreign keys.

For example, erwin generated:

ALTER TABLE RF_REINSURANCE_PARTICIPANT
       ADD FOREIGN KEY (CONTRACT_NUMBER)
                             REFERENCES RF_REINSURANCE_MASTER
                             ON DELETE RESTRICT;

I want erwin to generate:

ALTER TABLE RF_REINSURANCE_PARTICIPANT
       ADD CONSTRAINT [blue][b]FK_RF_RE_PART[/b][/blue] FOREIGN KEY (CONTRACT_NUMBER)
                             REFERENCES RF_REINSURANCE_MASTER
                             ON DELETE RESTRICT;

Any ideas?

 

[macehill]

You just be able to go the Table and then click on child relationship and rename the constraint that way.

 

[ddiamond]

I did that, and Erwin is displaying the correct relationship name. It is not using that relationship name, however, when it genarates the db2 ddl script.

 

[ddiamond]

I figured it out. On the other options tab, you have to check the "constraint name" check box if you want the constraint name to appear in your ddl.