Greg, I dont believe that you can issue a unique as a parameter to the MERGE.LIST. You will probably have to do a SELECT after the MERGE.LIST using a SAVING UNIQUE one more time to be sure that there arent any dups. If you have some time, then write a merger program that takes the list names as parameters and a unique parameter. Use that to do all you merging. The thing about merging is that if both lists arent active, it doesnt happen. If you write a program to do this, then you can control it much easier. Anthony
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Coelho, Gregory Sent: Saturday, February 25, 2006 7:55 PM To: [email protected] Subject: [U2] RE:Merging Unique Hey, I want 1st say thanks for all the help in the past - it is certainly a factor in why I still have a job! Can anyone let me know how I can merge using "Union" and be guaranteed that I have not pulled in any duplicate elements? I know I can "SAVING UNIQUE" when constructing a SAVE.LIST to ensure no duplicate ID's. Can I do something similar when merging? Thanks, Greg ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
