|
Are you using MBROPT(*REPLACE)? If you use MBROPT(*UPDADD) to a file with a unique key in any of its access paths, that will replace the record in the file with the new one each time there is a duplicate. So what you get is the last one in the file with that unique key. If that's what you are looking for, use MBROPT(*UPDADD). Francis Lapeyre IS Dept. Programmer/Analyst Stewart Enterprises, Inc. E-mail: flapeyre@xxxxxxxx -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of steema@xxxxxxxxxxxxx Sent: Friday, June 30, 2006 12:06 PM To: Midrange Systems Technical Discussion Subject: Strange problem w CPYF I have a series of CPYF to build a work file. On one of them, it bombs saying dup key issue, but I can't seem to find the exact record that is the culprit. IOW, the TO portion of the CPYF is a Unique key.
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.
midrange.com
