Re: Finding DUPS in a CMS file

[Marty Zimelis]

Title: Finding DUPS in a CMS file

David,

   A complete solution would require more information (e.g., more specifics on which of a set of records with duplicate keys is to be deleted).  Your preference to avoid sorting the file would seem to preclude Tom Kern's solution.  If you're a plumber, look at the LOOKUP stage of Pipelines with the AUTOADD parameter as the basis of a possible solution that doesn't require sorting the file.  (Though, depending on your answer to the question about the disposition of duplicates, that might not work either).

 

                    Marty Zimelis

 

---

From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Wakser, David
Sent: Tuesday, June 27, 2006 9:08 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Finding DUPS in a CMS file

All:

        Is there a "simple" method of finding (and possibly deleting) records in a CMS fixed-length file whose first 20 characters are the same? For example, if I have 5 records whose first 20 characters are the same, is there a method of recognizing them and possibly dropping specific ones?

        The only idea I came up with was to sort the file and manually "read" through (with EXECIO) and check them. Is there an easier way that I am missing?

        This needs to be done from a Rexx EXEC.

David Wakser
InfoCrossing
Confidentiality Note: This e-mail, including any attachment to it, may contain material that is confidential, proprietary, privileged and/or "Protected Health Information," within the meaning of the regulations under the Health Insurance Portability & Accountability Act of 1996. If it is not clear that you are the intended recipient, you are hereby notified that you have received this transmittal in error, and any review, dissemination, distribution or copying of this e-mail, including any attachment to it, is strictly prohibited. If you have received this e-mail in error, please immediately return it to the sender and delete it from your system. Thank you.