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

2004-05-03 Thread Stevenson, Charles
Title: Message



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.


{Virus?} Re: [U2] RE: Memo: RE: [UD] Union Query

2004-05-03 Thread Wally Terhune
Warning: This message has had one
or more attachments removed (graycol.gif, ecblank.gif, pic00981.gif). Please read the "VirusWarning.txt"
attachment(s) for more information.

I didn't follow this email thread, but (if it applies) wanted to point out that UniData does have a MERGE.LIST command that allows you to manipulate two active select lists into a third list with different options.

Wally Terhune
Manager - U2 Advanced Technical Services
IBM DB2 Information Management Software
Tel: 303.294.4866 Fax: 303.294.4832 
[EMAIL PROTECTED]  
 
www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online!

Don't miss out on the IBM DB2 Information Management Technical Conference
September 19-24, 2004 - Las Vegas, NV

[EMAIL PROTECTED]








[EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
05/03/2004 06:48 AM

Please respond to
u2-users








To
[EMAIL PROTECTED]


cc



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








No, UniData doesn't allow you to combine lists like this. One of the few things I miss from D3. 
-- 
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: Mark Johnson [mailto:[EMAIL PROTECTED]] 
Sent: Friday, April 30, 2004 9:37 PM 
To: U2 Users Discussion List 
Subject: Re: Memo: RE: [UD] Union Query 
 
 
My 2 cents on this topic and maybe it'll trigger a UD/UV response. 
 
D3 allows you to GET-LIST A-LIST B-LIST and you get them 
combined for your 
next process. 
 

This is a message from the MailScanner E-Mail Virus Protection Service
--
The original e-mail attachment graycol.gif
is on the list of unacceptable attachments for this site and has been
replaced by this warning message.

If you wish to receive a copy of the original attachment, please
e-mail helpdesk and include the whole of this message
in your request. Alternatively, you can call them, with
the contents of this message to hand when you call.

At Mon May  3 07:02:01 2004 the virus scanner said:
(graycol.gif)

Note to Help Desk: Look on the MailScanner in 
/var/spool/MailScanner/quarantine/20040503 (message i43E1vS19725).
-- 
Postmaster
This is a message from the MailScanner E-Mail Virus Protection Service
--
The original e-mail attachment pic00981.gif
is on the list of unacceptable attachments for this site and has been
replaced by this warning message.

If you wish to receive a copy of the original attachment, please
e-mail helpdesk and include the whole of this message
in your request. Alternatively, you can call them, with
the contents of this message to hand when you call.

At Mon May  3 07:02:01 2004 the virus scanner said:
(pic00981.gif)

Note to Help Desk: Look on the MailScanner in 
/var/spool/MailScanner/quarantine/20040503 (message i43E1vS19725).
-- 
Postmaster
This is a message from the MailScanner E-Mail Virus Protection Service
--
The original e-mail attachment ecblank.gif
is on the list of unacceptable attachments for this site and has been
replaced by this warning message.

If you wish to receive a copy of the original attachment, please
e-mail helpdesk and include the whole of this message
in your request. Alternatively, you can call them, with
the contents of this message to hand when you call.

At Mon May  3 07:02:01 2004 the virus scanner said:
(ecblank.gif)

Note to Help Desk: Look on the MailScanner in 
/var/spool/MailScanner/quarantine/20040503 (message i43E1vS19725).
-- 
Postmaster


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

2004-05-03 Thread 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 AMTo: [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.