Hello everyone!

I'm currently giving advice to a client on a project that is being developed for him by another group of contractors, and one thing that has been missing even though I've had him ask repeatedly for it, is a database schema (an er diagram).

For some reason that neither of us understands, he's getting nowhere with this and we need it in order to ensure that everything is up to specs with the application(s).

The data is stored in a db2 database in an as-400 box.

Is there any way to access this box and extract the information that we need?

Basically I need to get tables' structures, relationships, and views (if there's anything like that in the db-2/as400 world).

Thanks for your help!

Alex