Bill, See below. The first list contained 10 records. The second list contains the first 10, and 10 others. The commands yield only the 10 unique records that were not dup. If one list is larger, it has to be first in line on the merge. Does that help you any?
>GET-LIST DW1 TO 1 10 record(s) selected to SELECT list #1. >GET-LIST DW2 TO 2 20 record(s) selected to SELECT list #2. >MERGE.LIST 1 DIFF 2 TO 0 0 record(s) selected to SELECT list #0. >GET-LIST DW2 TO 1 20 record(s) selected to SELECT list #1. >GET-LIST DW1 TO 2 10 record(s) selected to SELECT list #2. >MERGE.LIST 1 DIFF 2 TO 0 10 record(s) selected to SELECT list #0. >>SAVE-LIST DW1 10 record(s) SAVEd to SELECT list "DW1". -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Wednesday, June 27, 2007 7:45 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Duplicate IDs in a list David: Thanks. But this doesn't remove duplicate IDs (nor does INTERSECTION). 7 Brpm (0)-> BSELECT ARTOPEN WITH AGE_60DAYS > "0" AND WITH DESC = "ASSOCIATION DUES" ACCOUNT 282 records selected to list 0. 7 Brpm (0)>> SAVE.LIST BILL 282 key(s) saved to 1 record(s). 7 Brpm (0)-> get.list BILL TO 1 282 records retrieved to list 1. 7 Brpm (0)-> get.list BILL TO 2 282 records retrieved to list 2. 7 Brpm (0)-> merge.list 1 UNION 2 282 record(s) selected. 7 Brpm (0)>> CLEARSELECT 7 Brpm (0)-> DL BILL 'BILL' deleted. It should reflect the following: 7 Brpm (0)-> BSELECT ARTOPEN WITH AGE_60DAYS > "0" AND WITH DESC = "ASSOCIATION DUES" ACCOUNT 282 records selected to list 0. 7 Brpm (0)>> U2.NODUPLIST 253 items selected. 7 Brpm (0)>> SAVE.LIST BILL Overwriting existing saved list. 253 key(s) saved to 1 record(s). 7 Brpm (0)-> DL BILL 'BILL' deleted. 7 Brpm (0)-> Thanks again, I was getting excited. :-) Bill >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of David A. Green >Sent: Wednesday, June 27, 2007 4:38 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] Duplicate IDs in a list > >GET.LIST DELINQ.LIST TO 1 >GET.LIST DELINQ.LIST TO 2 >MERGE.LIST 1 UNION 2 >SAVE-LIST DELINQ.LIST > >> GET.LIST DELINQ.LIST TO 1 >> GET.LIST DELINQ.LIST TO 2 >> MERGE.LIST 1 UNION 2 TO 3 >> SAVE-LIST DELINQ.LIST > >Thanks, >David A. Green >DAG Consulting > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett >Sent: Wednesday, June 27, 2007 3:47 PM >To: u2-users@listserver.u2ug.org >Subject: [U2] Duplicate IDs in a list > >I can't remember if I've asked this before but we occasional needed to >provide a custom script for our ASP clients. In D3 it looked >like: > >01 N >02 DISPLAY ...selecting items for processing >03 P >04 SSELECT ARTOPEN WITH DESC = "DELINQUENT CHARGE" AND WITH AGE < "30" >ACCOUNT 05 SL DELINQ.LIST >06 GL DELINQ.LIST {U >07 SL DELINQ.LIST >08 P >09 DISPLAY ...selection complete >10 FTWIZ > >A variety of people in our support department could build these kinds >of scripts. This is a D3 script. Line 03 hushes output, line >06 makes sure redundant IDs aren't selected. I've tried the usual >MERGE.LIST commands and can't get this to work in a paragraph. > >I guess my first problem is; does UniData have any ability to get a >list without selecting redundant IDs? I tried: > >GET.LIST DELINQ.LIST TO 1 >GET.LIST DELINQ.LIST TO 2 >MERGE.LIST 1 UNION 2 TO 3 >SAVE-LIST DELINQ.LIST > >...and it didn't work too well. I tried it in BASIC and that didn't >work too well either. I had to write a custom BASIC program to >use LOCATE to build an array then did a FORMLIST then a >SAVE.LIST. This was >pretty bogus and development staff have to get involved >in this. > >I'm in ECLTYPE "P" mode. Can anyone help? Thanks. > >Bill >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
