Concat multiple rows in one

Marcelomrwin · #1 (**permalink**) 12-27-07, 09:20

Hello friends, I need HELP...

I have the follow Table structure :

ID_CD

NM_CD

00019

TEXT001

00019

TEXT002

00019

TEXT003

00100

TEXT001

00100

TEXT002

00100

TEXT100

I need a SQL to do something like this:

ID_CD

NM_CD

00019

TEXT001,TEXT002,TEXT003

00100

TEXT001,TEXT002,TEXT100

Please.. someone can help me?

Peter.Vanroose · #2 (**permalink**) 12-27-07, 09:49

Quote:

Originally Posted by Marcelomrwin

Code:

ID_CD NM_CD
00019 TEXT001,TEXT002,TEXT003
00100 TEXT001,TEXT002,TEXT100

To do this kind of "aggragate concatenation", you need to use recursive SQL; see, e.g., http://www.dbforums.com/showthread.php?p=4481846

I've recently given a presentation at IDUG on nested table expressions in DB2, which also gives this particular example use of CTEs -- see http://www.abis.be/resources/present...1106ctedb2.pdf
(pages 44-50).

Marcelomrwin · #3 (**permalink**) 12-27-07, 09:53

Thank you Peter.. I will look your thread.