Querry using Catalog information..

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kanaka
    New Member
    • Sep 2010
    • 4

    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 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??
Working...