Page 1 of 2

tables comparsion

PostPosted: Fri Jan 04, 2013 10:17 pm
by balamurali cl
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...

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 12:27 am
by Akatsukami
What kind of tables: DB2, ISPF, kitchen...?

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 1:00 am
by balamurali cl
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

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 1:18 am
by Akatsukami
May we assume that the table always has a primary key?

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 1:32 am
by balamurali cl
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...???

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 1:34 am
by balamurali cl
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..???

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 1:44 am
by dick scherrer
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.

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 1:51 am
by enrico-sorichetti
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 ??? :mrgreen:

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 1:58 am
by balamurali cl
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...

Re: tables comparsion

PostPosted: Sat Jan 05, 2013 2:07 am
by enrico-sorichetti
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... ???

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