Hello all,
I have below SQLs to compare data between 2 identical tables.in my database.
Can any body help me to convert this into a script
db2 "select *from TAB1 where PK IN (select PK from TAB2) order by BEDG_NR".
Note:
These SQL should run for any given 2 tables as input TAB1 ,TAB2 and same primary key (PK).
This is db2 database
kanaka
Last Activity: Nov 10 '10, 01:23 PM
Joined: Sep 13 '10
Location:
-
Compare 2 identical tables script
-
Querry using Catalog information..
i have 2 identical tables tables in LUW database and host server ,
and i did a federation setup between LUW database and HOST db
now i have compared the data between these 2 tables and updated columns using below commands.
select *from LS77DB.TLPRZUL_ BEDG where BEDG_NR NOT IN (select BEDG_NR from LS77DB.TLPRZUL_ BEDG_tst) order by BEDG_NR;
select *from LS77DB.TLPRZUL_ BEDG_tst where BEDG_NR NOT IN (select... -
Comparision of 2 identical tables
Hi,
I have two database which reside on two different subsystem respectively.
I would like to generate a list of matching and non matching columns list ,keys,indexes .etc
that present in these two tables of different databases.
Do we have any sql to generate this report from SYSIBM tables.
i already has federated db setup in db2.
Thank you in advance. -
i am intrested to find differences between 2 identical tables in 2 different subsystem.even i already setup the federation setup.
can i have the SQLs to compare the columns,views,t riggers,keys,in dexes ..your help is really required.
THnaks kanaka
No activity results to display
Leave a comment: