Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes IDEs, Version Control and other tools and the fly likes Tools for DB2 on AS/400 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Tools for DB2 on AS/400" Watch "Tools for DB2 on AS/400" New topic
Author

Tools for DB2 on AS/400

Benson Fung
Ranch Hand

Joined: Apr 10, 2003
Posts: 214
Hi,

I am working on a project whose DB2 is on AS/400. Is there reverse engineering tools particularly open source like eclipse plugin which can provide ER diagram generation for such database?


Please advice

Thanks
Benson
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16897
    
  26

There's an open-source tool called SchemaSpy that I have found to be very useful. It can create an entire interactive website for the schema.

It's a Java application using JDBC, so you can do things like run the app on a Windows machine and analyze an AS/400 or even z/OS database as long as you have JDBC drivers.

I think you can find SchemaSpy on sourceforge.net. If not, Google.


Customer surveys are for companies who didn't pay proper attention to begin with.
 
 
subject: Tools for DB2 on AS/400
 
It's not a secret anymore!