Is there an equivalent aggregate function in DB2 for the MySQL function GROUP_CONCAT?
group_concat returns a string result with concatenated values from a group.
example...
SELECT student_name,
-> GROUP_CONCAT(test_score)
-> FROM student
-> GROUP BY student_name;
Tom , (3,4,4,3,2) <-- concatenated from the group
Ted, (4,54,3,34,)