Archives of the TeradataForum

Message Posted: Thu, 26 Jan 2006 @ 22:51:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Frank,

You are right, it does not look like ERwin will let you compress a primary key field. I think it is a case once again of the ERwin developers trying to save a DBA for him\herself!

I have not been able to write an ERwin script that actually changes the DDL it creates. So the way I handle PPI designations in ERwin is too specify a Post Creation script for each table that just writes out to the DDL file "Partition By ...." after the create table statement. I then go through and do a global search and replace to move the semicolon to after the PPI clause. I also use this method to do MultiSet tables as well. It at least lets me keep all data model info in ERwin.

Perhaps a similar approach to compressing PK fields could be used, but it would be hard. Otherwise, I am also very interested if anyone has ERwin scripts that could make either of our lives easier.

Good Luck,

Jason

P.S. If it's stupid and works, then it ain't stupid!

	<Prev	Next>		<<First	<Prev	Next>	Last>>