Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
concatinate rows for all repeated values in another column
Hi, My source data looks like this in DB2: COLA COLB MIS-1 4 off Strips of clamp rubber MIS-1 1 off roller bearing MIS-2 1 off Heater rod MIS-2 2 off 16mm dia x 299 ground shafts How can I concatinate COLB for all repeated COLA values. COLA COLB MIS-1 4 off Strips of clamp rubber 1 off...
