Personal tools
You are here: Home Forums DB2 Convert a table structure for a table
Navigation
Log in


Forgot your password?
 
Document Actions

Convert a table structure for a table

Up to DB2

Convert a table structure for a table

Posted by abcd at September 19. 2010

I 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
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls