× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I have used both ERWin and Embarcadero's ERStudio successfully with the AS/400, i Series and i5's. However, you should be aware that these products (and no product really can, witness the extraction maps of Ops Nav...) will only extract the basic definitions and the linking of the mapped objects is still a manual thing.

That being said, I did prefer ERWin for it's ability, once the relationships were all described, to produce change scripts in the base product.

Again, there is no shortcut to producing the models in these products. But once the work of migrating the meta-data into these models is complete, if you continue to use them, there are significant advantages and benefits in the long term aside from just the diagrams.

eftimios pantzopoulos wrote:
I'm working at a site which has a system that's been in place for over 15 years and has had lots of files (but no SQL DDL) added over the years after the base system was installed. No-one knows exactly what is in there and I want to create an ERD using some sort of tool. I know OPs Navigator has a function, but it doesn't seem rich enough in functionality. Does anyone use such a diagramming technique, and if so, any suggestions as to what product(s) might be useful with DB2?

I would presume that the tool could suck basic stuff out of DB2 and then provide drawing tools to relate foreign key relationships at least.

I've been using the Paul Conte/Mike Cravitz book as an SQL reference and I was thinking of the sorts of diagrams that they were using in chapter 20 of the book.

Searching in Midrange didn't provide any definitive answers.


Regards,
Mike Pantzopoulos

_________________________________________________________________
Advertisement: Your Future Starts Here. Dream it? Then be it! Find it at www.seek.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Ahet%3Ask%3Anine%3A0%3Ahot%3Atext&_t=764565661&_r=july07_endtext_future&_m=EXT



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.