[U2] RE: [UD] Union Query

[Burwell, Edward]

Unidata's MERGE.LIST is only half of the solution.  the sql> prompt looks like the other half.  Is there a way to pass an active list to the sql> statement?  Thanks.

 

Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512

-----Original Message-----
From: Wally Terhune [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03, 2004 9:40 AM
To: [EMAIL PROTECTED]
Subject: {Virus?} Re: [U2] RE: Memo: RE: [UD] Union Query

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.
>