Sounds like you wanted an *ADDNEW vs. *UPDADD....so sure merger might
make sense. I'll readily agree that MERGE is much more powerful than
CPYF *UPDADD. <<SNIP>>
On Mon, Feb 3, 2014 at 5:14 PM, Scott Mildenberger wrote:
How about the capability to do an IGNORE? I have a web service
that I retrieve records from, some of the records are duplicates
due to how a GPS generates records. I use a MERGE statement to
INSERT if the record doesn't already exist and to IGNORE it if it
is already in the database. Obviously there are other ways to
handle this but the MERGE seemed cleaner to me.
Charles Wilt on Monday, February 03, 2014 2:14 PM wrote:
I don't really see any benefits over CPYF MBROPT(*UPDADD)
FMT(*MAPDROP). Other than perhaps the ability to use commitment
control with merge.
Am I missing anything?
This mailing list archive is Copyright 1997-2014 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