RE: [U2] RE: Memo: RE: [UD] Union Query

[alfkec]

Title: Message

Sorry Charles, Wally, et al, I realize that UD has merge.list (only in ECLTYPE U). I was merely lamenting the fact that it doesn't have the remarkably handy feature of D3's get-list:

 

GET-LIST A B C D ... {(U}

 

The get-list will retrieve all items (including duplicates - which UD won't do) from as many lists as you like. The (U will only get the unique ID's. Much easier than trying to merge.list a whole bunch of items together....

 

Colin

 

P.S. Charles, I didn't mean to "correct" you last week with the convert statement. I know you know the difference. I just didn't want anyone to take you to literally and not use CONVERT without understanding why....

--
Colin Alfke
Calgary, Alberta Canada

"Just because something isn't broken doesn't mean that you can't fix it"

Stu Pickles

-----Original Message-----
From: Stevenson, Charles [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03, 2004 7:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] RE: Memo: RE: [UD] Union Query

Yes it does, albeit syntax is different.

 

2 ways:

 

LIST.UNION combines savedlists

        >GET.LIST LIST-A TO 1

        10 record(s) selected to SELECT list #1.

        >GET.LIST LIST-B TO 2

       10 record(s) selected to SELECT list #2.

        >MERGE.LIST 1 UNION 2

        19 record(s) selected to SELECT list #0.

    (see also related verbs:

        - LIST.INTERSECTION

        - LIST.DIFF )

 

MERGE.LIST combines active select lists.

        >LIST.UNION LIST-A

        WITH: LIST-B

        TO: LIST-C

        19 record(s) SAVEd to SELECT list "LIST-C"

    (See also related keywords

        - INTERSECTION

        - DIFF )

Note: an id that appears in both lists appears only once in resultant list. This may be differ from D3.

The above examples are from Universe, not Unidata,  but I'm pretty darn sure they're the same, since they are both PI-derivatives and if I recall correctly, those all came from PI.

 

No, UniData doesn't allow you to combine lists like this. One of the few things I miss from D3. 

>From: Mark Johnson [mailto:[EMAIL PROTECTED]]
>
>D3 allows you to GET-LIST A-LIST B-LIST and you get them
>combined for your next process.