If only structure


Just sql from sysibm.syscolumns for both table , if that has constraints ,
sysibm.systabconst


For both tables



Lekharaju Ennam

-----Original Message-----
From: Bala Sosale
[mailto:db2udbdba-ezmlmshield-x58321215.[Email address protected]
Sent: Wednesday, August 31, 2005 2:11 PM
To: LazyDBA Discussion
Subject: comparing 2 tables of same structure

Dear list members,

What is the best way to compare 2 tables of same structure and flag out
the differences in a third table of the same structure?

Thanks
Bala


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page