Posted: Thu Jan 19, 2006 3:03 pm Post subject: File compare process
Hi,
On this forum I learned about ICETOOL/SYNCTOOL which we use to do the file compare process. Which is really helpful. But is there a better way of reporting the discrepancies by filed wise or column wise. currently it writes 2 files with discrepancies based on the key.
What I am looking for is, I would like to match on the key and for matched reocrds compare the rest of the fields then report only those fields (positions) which are not matching along with the key information, that too in one file.
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
Posted: Fri Jan 20, 2006 1:12 am Post subject:
Pradeepq,
What you are looking at is a full-fledged dataset comparison tool. You can ofcouse, utilize the power of Sort and other general purpose utilities, but you have to build a tool yourself either using a high-level language, rexx, assembler or a combination of all these.
The simple answer would be, do the compare using sort - read the output dataset using any other programming language and generate a report to list the discrepancies!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
