MVSFORUMS.com

[zefrim]

HI

I would like to compare the structures of two tables to determine
whether the tables have different field names.

In a step 2.ten I would also compare the field characteristics.

Maybe someone has a matching SQL

thank you

Zefrim

[dbzTHEdinosauer]

here is a link to Retrieving catalog information about a table
and here is one about Retrieving catalog information about columns

this is link Retrieving information from the DB2 catalog, using SQL statements, is basically a list of info that you can retrieve.

if you need more help, post your question(s).
_________________
Dick Brenholtz
American living in Varel, Germany