compare the values from text file

kenare · #1 (**permalink**) 12-03-03, 08:59

I am using DB2 v8.1 on windows 2000.

I have data in my text file and I need to compare this data with the data in my db2 table. Can I have the solution for this?

Thanks in advance
Kenare

sathyaram_s · #2 (**permalink**) 12-03-03, 09:09

You can write a table function (in Java, C ) and read the flatfile as a table ...
Then you can compare against the db2 table ..

Search for 'Table function' in the documentation

Cheers
Sathyaram

Quote:

Originally posted by kenare
I am using DB2 v8.1 on windows 2000.

I have data in my text file and I need to compare this data with the data in my db2 table. Can I have the solution for this?

Thanks in advance
Kenare

Internet Services

Web Development

Digital Marketing

Consumer Tech