IBM Mainframe Forum

Hi all,

Using REXX we can compare two tables...In the same way can I compare two tables..??

I want to compare two tables because I am using different load utilities for loading data into tables...

Any idea would be of great help...

What kind of tables: DB2, ISPF, kitchen...?

Two DB2 tables....I will load the two tables with the same input file but using two different load utilities....So now I want compare the two tables...pls suggest me the procedure...So that I can develope ths tool...thanks

May we assume that the table always has a primary key?

NO....it may have or nt have the primary key...the count query may tell if the no of rows are equal in both tables....but as we compare two files...cant we compare the data in tables...???

Tell me how to compare when it has primary key ..and if we dont have primary key...please suggest me some way to do this...is this possible..???

Hello,

Why do you believe there is a possibility that the table content would not be the same

You could always unload the tables (in key sequence) and compare the unloaded data.

Two DB2 tables....I will load the two tables with the same input file but using two different load utilities....So now I want compare the two tables...pls suggest me the procedure...So that I can develope ths tool...thanks

why do You feel that the <loaded> tables would be different ?
if the load utilities come from <primary> software providers it will be just a useless waste of time

topic going down the toilet ???

yes....the comparsion can be done after unloading data to file...but I want to do without unloading...


There may be difference in data because....we are trying to use another utility then that exists now in production...for cost save...so we will replace all the parameters...so there may be difference...so to confirm its the same...we want to compare...

There may be difference in data because....we are trying to use another utility then that exists now in production...for cost save...so we will replace all the parameters...so there may be difference...so to confirm its the same...we want to compare...

did You care to try to understand about reliability of software provided by <primary> companies ???
naturally if You go cheap such guarantees do not exist

also why not ask the new software provider about the conversions tasks... ???

Your organization is money saving mode so You thought better to get free consultancy on a forum