Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Unanswered: Tools for auto-generate table structures from DB2 database

    Hello,

    Do anyone know if there are any tools to automatically generate DB2 table structures (including table names, columns, relationship, etc), which I'd like to include in a Word file (better in table format)?

    I'm now just manally key in the field names, attributes in tables of a Word file. Can anyone help?

    Thanks~
    Sze

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by wsleung9
    Hello,

    Do anyone know if there are any tools to automatically generate DB2 table structures (including table names, columns, relationship, etc), which I'd like to include in a Word file (better in table format)?

    I'm now just manally key in the field names, attributes in tables of a Word file. Can anyone help?

    Thanks~
    Sze
    db2look give it to you in raw text format.

    You could do queries on the SYSCAT tables, ie. SYSCAT.TABLES, etc.

    jono
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Aug 2004
    Posts
    330
    You could use BMC's Catalog Manager and use the HDDL command at the database level.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •