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 BEDG_NR from LS77DB.TLPRZUL_ BEDG) order by BEDG_NR;
select *from LS77DB.TLPRZUL_ BEDG A JOIN
LS77DB.TLPRZUL_ BEDG B ON
A.BEDG_NR=B.BED G_NR where
A.MANDANT_NR <> B.MANDANT_NR or
A.OBJEKT_VERSIO N <> B.OBJEKT_VERSIO N or
A.BEDG_KURZBEZ <> B.BEDG_KURZBEZ or
A.BEDG_NAME <> B.BEDG_NAME or
A.BEDG_BESCHRBG <> B.BEDG_BESCHRBG or
A.F_ONLINE_NAME <> B.F_ONLINE_NAME or
A.REIHENFOLGE <> B.REIHENFOLGE or
A.BEDG_ART_NR <> B.BEDG_ART_NR or
A.BEDG_DLCBEZ <> B.BEDG_DLCBEZ or
A.SELEKTIONSNR <> B.SELEKTIONSNR or
A.KZ_INHALTSVER Z <> B.KZ_INHALTSVER Z;
is there any way to do these 3 steps using syscatlog tables for a given 2 tables??
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 BEDG_NR from LS77DB.TLPRZUL_ BEDG) order by BEDG_NR;
select *from LS77DB.TLPRZUL_ BEDG A JOIN
LS77DB.TLPRZUL_ BEDG B ON
A.BEDG_NR=B.BED G_NR where
A.MANDANT_NR <> B.MANDANT_NR or
A.OBJEKT_VERSIO N <> B.OBJEKT_VERSIO N or
A.BEDG_KURZBEZ <> B.BEDG_KURZBEZ or
A.BEDG_NAME <> B.BEDG_NAME or
A.BEDG_BESCHRBG <> B.BEDG_BESCHRBG or
A.F_ONLINE_NAME <> B.F_ONLINE_NAME or
A.REIHENFOLGE <> B.REIHENFOLGE or
A.BEDG_ART_NR <> B.BEDG_ART_NR or
A.BEDG_DLCBEZ <> B.BEDG_DLCBEZ or
A.SELEKTIONSNR <> B.SELEKTIONSNR or
A.KZ_INHALTSVER Z <> B.KZ_INHALTSVER Z;
is there any way to do these 3 steps using syscatlog tables for a given 2 tables??