MVSFORUMS.com

Nithisha

hi friends

I have probelm in data mismatch bewteen the db2 table and warehouse table.
Basically db2 updates the warehouse table. please suggest how to rectify or how find the difference between two table

How to compare two table Operational: Warehouse:

Description:

We would like to have queries written to verify that all claims and payments data that exist on InterGroup operational tables match what is on our warehouse tables.

I'd like these to be reusable queries that we can run from time to time to make sure that finance doesn't find data missing from the warehouse.

The tables we're talking about are:

Operational: Warehouse:

Claim : ABCD_REQSTDEL_TB_DB SAT_LNDDTL_WH

Payment:EFCH_FINTRAN_TB_DB GAY_LNDPMT_WH

Please suggest how to check or resolve the problem.

Thanks
nithish

kolusu · Posted: Thu Sep 28, 2006 8:10 am Post subject:

Nithisha,

you need to provide more details. When you say warehouse table, what is the Database ? You say that DB2 table updates the warehouse tables. What happens if some other program or query updates either the DB2 table or the warehouse table?

How are you planning to run queries? Is the Warehouse table also on Mainframe?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Nithisha

I wish to run a querry in mainframe environment. both are in same environment but in a different table like db2 table and warehouse table .
Can please give me querry how to get the difference between the two table.

awaiting for reply

Thanks
sathishkumar

kolusu · Posted: Thu Sep 28, 2006 9:38 am Post subject:

Nithisha,

difference between 2 tables? Do you want to compare specific columns or all the columns? Can you provide a sample input of the data and desired output?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Nithisha · Posted: Thu Sep 28, 2006 10:26 am Post subject:

Hi Kolusu

I want to compare all column and give the diffence between the two table.

can please suggest how to go about.

Thanks and regards
nithish

kolusu · Posted: Thu Sep 28, 2006 10:31 am Post subject:

Nithisha,

1. Unload table1 with an ORDER by on the primary columns
2. Unload table2 with an ORDER by on the primary columns.
3. Use Superc/sort/easytrieve/cobol to compare these and write out the differences.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Nithisha · Posted: Tue Oct 03, 2006 4:14 am Post subject:

Hi kolusu

That is good idea ,But they want it in the form of SQL so that they can use it any time.Can please suggest any sql so that i can find the mismatch data between the two table.
Thanks
sathishkumar