> -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Wayne Bickerdike > Sent: Tuesday, August 03, 2010 4:34 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. > It all could be done in DB2 using INSERT and report duplicates though. Ouch! Talk about an expensive solution... 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
