Re: Data modeling tool

At 11:53 AM 7/10/1998 -0400, you wrote:
>Hi there folks - I have a BP asking me for advice on a data modeling tool for
>AS/400.  It has to accommodate both existing databases and assist in
designing
>new ones.  They have looked at Silverrun, but find the "bridging" a bit
awkward.
>
>I know I've seen references here before but foolishly forgot to file them.
>
>Any thoughts?

Sybase' Data Architect, etc., have some knowledge of AS/400 databases. It
did not handle the referenetial integrity stuff when I last looked at it,
but they've had upgrades since then. The product is fairly intuitive to
use. Some funniness but not bad. Used to be Powerbase' S-Designor.

ERWin also knows about AS/400. It was not as easy to use as Data Architect,
however.

Popkin has a similar tool, called System Architect, I think.. It had AS/400
knowledge but had only an APPC connection—no TCP/IP. That may have changed.

There are a number of other tools along the line of data modelers or OO
design tools. The above-mentioned tools can all reverse-engineer. They also
have other components that can generate commands, usually SQL and
occasionally DDS, that can create files/tables on the server database.

Check WebFerret (have you picked it up yet) for data modeling.

HTH

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---