Check your output again because it's inconsistent. You might be looking for either of the string functions CONCAT or CONCAT_WS. You might need a GROUP BY clause on your statement to make it work.
Before you start wondering how to make this work I suggest that you start by fixing the other errors in your statement and enjoy the speed increases they give.
Joined: Dec 31, 2008
if you see the result set first....i am getting per policy id two role codes. so i need either function or modification in query such that the roles should come in single row with comma separated. I am using DB2 9.5 version.