Re: Looking for a way to implement SQL-92 Domain

On 25 Mar 2003, wizofoz2k_at_yahoo.com.au wrote:

> One of ours guys even wrote a PL/SQL proc that extracts all the
> design into a XML file directly used by WSAD in the Websphere
> environment for autogen of Jave DAOs! Magic stuff. All I have to
> do is change the design, patch up the database side of it with
> the proper info and run all the scripts. Out comes the other end the
> basics of all the code, plus scripts for generating schema. And
> enough XML to keep a pack of Java developers happy for months! <G>

That sounds really slick and the pack of java developers think you are cool cause you talk DAO's. :-)

> However, Erwin runs rings around Designer when it comes to speed
> and reporting!

Erwin is a tool that I've used for awhile now. The thing that sucks is that it got bought by Computer Associates so there ain't much new stuff going to happen to that product. But then again, there ain't much new stuff happening in data modeling either. Tying things to the specific platform has lots of merits. Like here's a simple but extremely frustrating lack in Erwin. I can't create a sequence and tie it to a table if I need. I don't even need for some create trigger to be created. I would just like to say that a domain type gets a sequence, please create me the correct one. The only thing I can do is create a sequence. Whoo Hoo... So, I create them and store them in a file that gets in CVS. :-(

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.