How to compare two recordset on from DB2 and another from excel sheet

shahid09 · #1 (**permalink**) 10-16-08, 23:11

Hi All,

I have two tables one from DB2 and another from an Excel.
Using VB script I am creating 2 recordset which should give exact same record from the table. Is there anyway i can compare these two tables using SQL query ?
I want to make sure Values populated in excel sheet is exactly same as DB2 .

Thanks,
Shahid

przytula_guy · #2 (**permalink**) 10-17-08, 06:59

use federated with non-relational wrapper (windows)

shahid09 · #3 (**permalink**) 10-17-08, 15:03

Hi Thanks,

Can you plese give me little bit more hints on this ?

Thanks

przytula_guy · #4 (**permalink**) 10-18-08, 10:33

you need websphere federation server and non-relational wrappers
in that case you can define excel sheets as dbé tables
have a look at infocenter and search for excel federated
all info is over there

Internet Services

Web Development

Digital Marketing

Consumer Tech