IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Combining Multiple Row Values into Single Row SQL DB2 V6R1


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
parora

New User


Joined: 05 Jun 2021
Posts: 1
Location: Canada

PostPosted: Sat Jun 05, 2021 5:21 am
Reply with quote

In V7R1 and above, there are functions like xmlserialize, xmlagg, xmltext, to display multiple row values into a single row, but how can this be performed via SQL in DB2 V6R1?

Thanks.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Sat Jun 05, 2021 12:02 pm
Reply with quote

this is a IBM mainframe support forum

You are asking a question about an I series software
and I series db2 v6r1 reached its lifecycle end in 2018 ( after an extension from 2015)
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA

PostPosted: Sun Jun 06, 2021 10:10 am
Reply with quote

Share us sample input and output expected. We are in V12R10, are you really that back?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Sun Jun 06, 2021 1:03 pm
Reply with quote

again ...
DB2 v6r1 and DB2 v7r1 are I series products, not zOS products
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Grouping by multiple headers DFSORT/ICETOOL 7
No new posts How to append a PS file into multiple... JCL & VSAM 3
Search our Forums:

Back to Top