put the result into list

missNyza · #1 (**permalink**) 12-21-10, 21:46

Hi,
i have a data like below

CASE_ID YEAR
---------- -------
776 2007
776 2008

i want to get the year as a list for example

CASE_ID YEAR
776 2007,2008

can i get it without using stored procedure?
Any help would be most appreciated. Thanks.

Lim Tjie Siong · #2 (**permalink**) 12-22-10, 05:57

I'm not sure in db2. If I were you, I will shell script to do it.

sanjsajjan · #3 (**permalink**) 12-22-10, 06:24

U can get output like that using simple query.

select case_id,wm_concat(year)
from table_name
group by case_id

Thanks,
Naganath

dbzTHEdinosaur · #4 (**permalink**) 12-22-10, 09:25

is the oracle function wm_concat, also for db2?

missNyza · #5 (**permalink**) 12-23-10, 01:45

i'm using db2. wm_concat will give error SQLSTATE: 56098.
maybe i should use shell script as suggested.

thanks.

JAYANTA_DATTA · #6 (**permalink**) 12-28-10, 14:32

you can refer the db2 sql cookbook and find few examples there to denormalize result set in the output ( there are few for normalizing too). That will give you some direction.

Internet Services

Web Development

Digital Marketing

Consumer Tech