Convert a table structure for a table
Up to DB2Convert a table structure for a table
Posted by abcd at September 19. 2010I need a few instuructions how to approach the following scenarios.For a given TABLENAME a script should display the following
structure on the screen.The structure should be as below.for a given perticular table.
SELECT *FROM TAB1 a JOIN
TAB1 b ON
a.PK1=b.PK1 where
a.col1 <> b.col1 or
a.col2 <> b.col2 or
a.col3 <> b.col3 or
.
.
.
.
a.coln <> b.coln ;
The above structure is useful to check the updated records count to
compare with old version table.Please help to suggest an approach to do
this or any commands will do for this ?
Powered by
Ploneboard