Greg,
The quick and dirty way to do this. You will end up with a
de-duped, sorted save list.:
>CLEAR.FILE JUNQUE
>GET-LIST LIST1
>RUN BP MAKE.EMPTY
>GET-LIST LIST2
>RUN BP MAKE.EMPTY
>SSELECT JUNQUE
>SAVE.LIST LIST3
Here's the code for BP MAKE.EMPTY:
<comments go here>
FERR = ''
OPEN 'JUNQUE' TO JUNQUE.FILE ELSE FERR = 'JUNQUE'
IF FERR # '' THEN ABORT 201, FERR
*
DONE = 0
LOOP
READNEXT ID ELSE DONE = 1
UNTIL DONE DO
WRITE '' ON JUNQUE.FILE, ID
REPEAT
I typed the code from memory, so check it carefully.
- Chuck
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/
--
- Charles Barouch
[EMAIL PROTECTED]
(718) 762-3884 x 1
P. O. Box 540957,
Linden Hill, NY 11354-0957
www.KeyAlly.com
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
