Archives of the TeradataForum
Message Posted: Fri, 27 Jan 2006 @ 18:51:36 GMT
| Subj: | | Re: Erwin is not mi amigo again... |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, January 27, 2006 11:00 -->
| | 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. | |
The PPI is easier if you issue an ALTER statement in the post script. This method eliminates the need to do any editing and enables me to
execute the DDL directly from ERwin all the time. It also does not conflict with all my COMMENT statements that are generated for each table and
column.
ALTER TABLE XYZ
MODIFY PRIMARY INDEX
PARTITION BY RANGE_N(Calendar_Week_Nbr BETWEEN 0 AND 53 EACH 1 );
As far as MULTISET is concerned I don't use it because it violates relational theory. MULTISET and DUCT TAPE are, IMHO, one and the
same. I don't see a way for ERwin to generate that.
Anonym
| 
