"Sirin Venigalla" <a_at_abc.com> wrote in message news:<WoCG8.90740$2G1.31110535_at_typhoon.nyroc.rr.com>...
> 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
My question is how to map value 'abc' to column value1, value 'cde' to
column value2 and value 'xxx' to column value3.
If you could clarify that point, it would be not so difficult to solve
this problem.
Received on Wed May 22 2002 - 05:44:07 CDT
