If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Announcement
Collapse
No announcement yet.
Combining Multiple Row Values into Single Row SQL DB2 V6R1
Combining Multiple Row Values into Single Row SQL DB2 V6R1
In V7R1 and above, there are functions like xmlserialize, xmlagg, xmltext, to display multiple row values into a single row & column, but how can this be performed via SQL in DB2 V6R1?
If you stuck on release 6.1 there is no way to use this functions.
If you want to use SQL you need to build the strings manually by concatenating the information ... which is rather complicated.
It might be easier to use CGIDEV2 and RPG for generating the xml data
Comment