Xref: alice comp.databases.oracle.misc:52527 comp.databases.oracle.tools:39545
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.icl.net!diablo.theplanet.net!news.theplanet.net!newspost.theplanet.net!not-for-mail
From: "Christopher M. Day" <christopher.day@rdbms.freeserve.co.uk>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools
Subject: Re: Problems with ERwin and Oracle8 check constraints and comments
Date: Thu, 03 Feb 2000 00:20:37 +0000
Organization: Customer of Planet Online
Lines: 41
Message-ID: <3898C9D5.239F8F96@rdbms.freeserve.co.uk>
References: <877gvv$ha5$1@newsread.f.de.uu.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news6.svr.pol.co.uk 949623792 11081 62.136.94.80 (4 Feb 2000 00:23:12 GMT)
NNTP-Posting-Date: 4 Feb 2000 00:23:12 GMT
X-Complaints-To: abuse@theplanet.net
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en,zh-TW

Stefan,

I've encountered these problems, although the UK support has promised
they will be fixed in release 4.0 of ERWin in April.

There are a lot more problems in the volumetrics editor.

Stefan Misch wrote:
> 
> Hi everybody !
> 
> I have two problems with ERwin (3.5.2-SP2) which I could not solve with
> Platinum/CAI support (I got no answer), nor found any hint in their
> knowledge base:
> 
> (1) when I add a column in an existing table in an Erwin modell and generate
> an alter-script using the "Alter database" task, the column is added, but
> the column's comment not. I have to do another "alter database", then ERwin
> generates a second script with just the "comment on column..." statement.
> 
> (2) TABLE and COLUMN check constraints
> The problem here is that when I do an "alter database" with the options
> "Table check" and "Column check" enabled in the "Set Options" dialog, these
> options generate lots of differences between my model and the database. For
> example:
> 
> If I define a not null column with a check constraint :CHECK EXAMPLE_YN in
> ('Y', 'N') ERwin reports
> 
> (a) EXAMPLE_YN in ('Y', 'N') as a table check constraint on the database
> side, but none (displayed as "---") on the model side
> 
> (b) and further down the list a difference at column EXAMPLE_YN on a line
> tagged "check": CHECK EXAMPLE_YN in ('Y', 'N') on the modell side and
> "EXAMPLE_YN IS NOT NULL" on the database side
> 
> Is this a bug in ERwin or is something wrong with my modell, set option or
> installation ?
> 
> Thanks for any tip !
> Stefan.