>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).
Others have posted messages here about attaching to DB2, IIRC they use an ODBC driver. Sorry I don't have any details on how the schema is stored in DB2.
You might want to be careful doing this, the other contractors may consider this privileged or proprietary intellectual property. For example, what is there now may be your client's database, plus other proprietary data structures for development or testing that may not be part of the deliverables. If you extract the latter you could be in a lot of hot water.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up