Tools for auto-generate table structures from DB2 database

wsleung9 · #1 (**permalink**) 11-01-04, 22:39

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

J Petruk · #2 (**permalink**) 11-02-04, 08:13

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

urquel · #3 (**permalink**) 11-02-04, 12:11

You could use BMC's Catalog Manager and use the HDDL command at the database level.

Internet Services

Web Development

Digital Marketing

Consumer Tech