Hi All,
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 roller bearing
MIS-2 1 off Heater rod 2 off 16mm dia x 299 general shafts
Any help would be great.
Thanks
Srimitta
Concatenation of multiple row string values to one column
Moderators: chulett, rschirm, roy
Concatenation of multiple row string values to one column
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 1
- Joined: Tue Nov 03, 2009 4:15 am
PLs Help
Hi,
How to do this Job?I tried but unable to resolve.Pls help
How to do this Job?I tried but unable to resolve.Pls help
And you would be whom? First post at the end of someone else's months later doesn't help things much.
Start your own post in the appropriate forum. Include the details of what you need to do there (not here). Then people will be able to help.
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers