Re: Column aggregating for text columns

From: Bob Hairgrove <rhairgroveNoSpam_at_Pleasebigfoot.com>
Date: Wed, 22 May 2002 20:10:58 GMT
Message-ID: <3cebfb88.9257201@news.ch.kpnqwest.net>

On Wed, 22 May 2002 01:21:58 GMT, "Sirin Venigalla" <a_at_abc.com> wrote:

>I found this interesting question on another forum. I am going to work on
>it, but if anyone has a solution please post it.
>
>--------------------------------------
>How do i convert this data in a table
>id value
>123 abc
>123 cde
>123 xxx
>to a query output
>
>id value1 value2 value3
>123 abc cde xxx
>
>I am using DB2 UDB 7.X
>

DB2 should support the newer SQL "LIST" function.

Bob Hairgrove
rhairgroveNoSpam_at_Pleasebigfoot.com Received on Wed May 22 2002 - 15:10:58 CDT