Combining rows into a single column

#1

Consider the following table (Single level of hierarchy ... No need for
recursion)

PRIMARY_COLUMN SECONDARY_COLUMN
-----------------------------
-----------------------------------

PARENT -
CHILD1 PARENT
CHILD2 PARENT
CHILD3 PARENT

Is it possible to display the results as follows with the child rows
concatenated into a column

PARENT_DATA CHILD_DATA
---------------------- ----------------------

PARENT CHILD1,CHILD2,CHILD3

Thanks in Advance...

#2

Sorry i missed one point - If the above is possible using pure SQL (no
stored procs) ?

#3

Brian Tkatch wrote:

Quote:

Search for XMLAGG() functions in the newsgroups.
plug>.. or come to IDUG/IIUG Conf. Europe in Vienna first week of

October and attend my talk.</plug>

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

#4

Hi Serge,

Would love to attend the Conference..Wish my employer reads this
message
<sigh>
Me getting to Conference would take a couple of years more..
<sigh>
I just started my career..Fresh out of college..
Plunged into the Ocean of queries and stored procs..Managing to survive
with this group..and a lot of intelligent beings around..

RaInDeEr

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Combining rows into a single column

comp.databases.ibm-db2 comp.databases.ibm-db2

Combining rows into a single column - 05-24-2006 , 06:18 AM

Re: Combining rows into a single column - 05-24-2006 , 06:22 AM

Re: Combining rows into a single column - 05-25-2006 , 04:54 AM

Re: Combining rows into a single column - 05-25-2006 , 05:41 AM