|
To me, this is an ideal spot for using the cycle and primary/secondary matching records, if the key fields are identical. It would be even faster if the files were reorganized first, but I bet that reorg would be a killer. --------------------------------- Booth Martin http://www.martinvt.com --------------------------------- -------Original Message------- From: Midrange Systems Technical Discussion Date: 10/14/04 23:13:09 To: Midrange Systems Technical Discussion Subject: Re: Setting parms in CL for PF I'm reading a record in File1 and chaining to File2. If no record is found, it writes to File2. If record is found, it then checks about 5 fields and if the fields are identical in both records, no update is performed. If they're not the same, the info from File1 is moved and written to File2.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.