> -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[email protected]] On Behalf Of Wayne Bickerdike > Sent: Tuesday, August 03, 2010 9:46 PM > To: [email protected] > Subject: Re: SuperCE > > >> Um, no. > >> > >> Two file matches don't work too well without a sort. > > > > Not true. Comparex, for example, permits definition of > "random order" keys with no pre-sorting of files to be > compared, and will very accurately tell you where records are > inserted or deleted as well as equal-key records with differing data. > > If Comparex does this without any sorting, it must have limits.
If it does, I never found them out, even on large records (>= 8,000 bytes) and record counts in the several millions. > Sort and compare is the lowest, KISS way to achieve this. The language > is irrelevant for the process. I nominated REXX because of the simple > integration with ISPF but obviously that has limits on the size of > dataset that can be brought into memory etc. > > >> It all could be done in DB2 using INSERT and report > duplicates though. > > > > Ouch! Talk about an expensive solution... > > Comparex is free? Cheap? > > My copy of DB2 Personal edition was free and FTP and disk space on my > laptop is real cheap. Just bought a terabyte for $75. I was replying in the spirit of mainframe-only solutions. Comparex is anything but cheap in software costs, but I was referring to the execution-time cost of DB2 on a mainframe, not to software costs. Not to mention you would have to be a DB2 admin on the mainframe to define the working-set table you need for each different record length and key position, and most ordinary programmers needing files compared are not DB2 admins. Nor, in my experience, would most large-shop DB2 admins permit such a random set of definitions to even be requested, much less implemented. Peter This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
