Funny, we ran into this in the last few days. Also on V7R1.

One of the developers banged together a CPYF similar to what you did and it copied additional records when there were trailing blanks in the key. After trying several workarounds he could not get it to work to always copy only the desired record.

He has since sworn off CPYF & INCREL and replaced it with SQL. [ Insert into newfile (select * from oldfile where condition)]. This is a much more precise and IMHO reliable approach

In hindsight, I recollected reading about this in the past and one of the other developers turned up some internet discussion. I suspect IBM will not change anything.


On 5/7/2013 6:34 PM, Steve Landess wrote:
That is what I thought. However, I believe that I will wait for Mr. Pence's response before I call IBM.

Paul wrote:
I think you should only get the 1 record.

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot 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 here. If you have questions about this, please contact