[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/
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/
RE: [U2] Duplicate IDs in a list
Have you looked at the "SAVING UNIQUE" clause of the SSELECT statement? Not
sure if it works under ECLTYPE "P", but it's worth a look.
Larry Hiscock
Western Computer Services
-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/
Re: [U2] Duplicate IDs in a list
Bill Haskett wrote: 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 Not certain about Unidata; in the version of Universe I'm running, this works, (assuming that DELINQ.LIST is a list of IDS to DELINQ.FILE): PA GET.LIST DELINQ.LIST SELECT DELINQ.FILE SAVING UNIQUE @ID SAVE.LIST DELINQ.LIST HTH. -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Duplicate IDs in a list
Numbered lists work in ECL type U mode (you can always use the lower case
versions of the verbs to force U mode - even in a PROC).
There is also the SAVING UNIQUE keyword.
Wally Terhune
U2 Support Architect
IBM Information Management
4700 South Syracuse Street, Denver, CO 80237
Tel: 303.773.7969
Fax: 303.773.5915
[EMAIL PROTECTED]
"Bill Haskett"
<[EMAIL PROTECTED]
os.net>To
Sent by:
[EMAIL PROTECTED] cc
stserver.u2ug.org
Subject
[U2] Duplicate IDs in a list
06/27/2007 04:47
PM
Please respond to
[EMAIL PROTECTED]
er.u2ug.org
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/
[demime 1.01d removed an attachment of type image/gif which had a name of
graycol.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
pic12116.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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/
RE: [U2] Duplicate IDs in a list
All: Awesome! I keep forgetting this. :-o Thanks, Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton >Sent: Wednesday, June 27, 2007 4:55 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Duplicate IDs in a list > >Bill Haskett wrote: > >> 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 > > >Not certain about Unidata; in the version of Universe I'm >running, this >works, (assuming that DELINQ.LIST is a list of IDS to DELINQ.FILE): > >PA >GET.LIST DELINQ.LIST >SELECT DELINQ.FILE SAVING UNIQUE @ID >SAVE.LIST DELINQ.LIST > >HTH. > >-- >Allen Egerton >aegerton at pobox dot com >--- >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/
RE: [U2] Duplicate IDs in a list
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/
