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

how to concatiante the 2 coloms
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
raju_rangam
Warnings : 1
New User


Joined: 31 Mar 2005
Posts: 25
Location: bangalore
PostPosted: Wed Jan 11, 2006 3:12 pm
 Reply with quote
hai friends,

how to concatinate the values of 2 coloms;

suppose

Table c1 Table c2
IBM Mainframes


iwant like

Table c3
IBMMainframes

regards
raju
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 677
Location: NJ
PostPosted: Wed Jan 11, 2006 3:35 pm
 Reply with quote
Hi Raju,

Try this sorry if i m wrong..

SELECT C1,C2, CONCAT(C1,C2) FROM TABLE;

Let me know if it is wrong...
Back to top
View user's profile Send private message
raju_rangam
Warnings : 1
New User


Joined: 31 Mar 2005
Posts: 25
Location: bangalore
PostPosted: Wed Jan 11, 2006 4:03 pm
 Reply with quote
hi,

thanks
its working....


regards
raju
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

 

Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us