ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Combining Multiple Row Values into Single Row SQL DB2 V6R1

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

    Thanks.

  • #2
    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

    Working...
    X