This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 207
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: 15632
    
  15

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Tools for DB2 on AS/400
 
Similar Threads
About using JBoss
AS400 and JDBC (and SQL)
what is connection pooling?
DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script
Using JDBC java code - how can I connect to IBM AS400 iSERIES to read data