I have a VB input file which contains duplicate records.All these duplicate records must be eliminated that is the first occurrence of the duplicate record must also get eliminated from my output file.For eg.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Here's a DFSORT/ICETOOL job that will do what you asked for. Since you want the records in their original order (rather than in sorted order), you need an extra pass over the data.
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
Well,
DFSORT's ICETOOL is a fully documented, fully supported feature of DFSORT, if I'm not mistaken ICETOOL has been with DFSORT since 1991. If you can use DFSORT you can use ICETOOL. Below link might provide a better understanding of ICETOOL
DFSORT's ICETOOL is an extension of DFSORT that allows you to do many tasks more easily than you can using DFSORT alone as in this case. So I can't imagine why the people at your site are forcing you to do it with DFSORT instead of with DFSORT's ICETOOL.
Your site's license for DFSORT includes ICETOOL, so why wouldn't they want to take advantage of it? ICETOOL HAS been a part of DFSORT since 1991. It is proven technology and after having been around for almost two decades is certainly not new or risky. I'd suggest you ask whoever it is who says you can't use it what their justification is for not getting the most out of a product they're paying good money for. You can point them to the complete documentation of DFSORT's ICETOOL on IBM's official publications website at: