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

Convertion decimal integer to char


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
delago

New User


Joined: 29 Jul 2005
Posts: 21
Location: Brazil

PostPosted: Wed Sep 16, 2009 9:04 pm
Reply with quote

Hi people,

I need a little question.
I try be to mount a query with some collums, but I need to concat 2 collums.
The first collum is decimal with 3 positions.
The second collum is decimal with 16 positions.
So:
CAMPO_01 - DECIMAL(3, 0) NOT NULL
CAMPO_02 - DECIMAL(16, 0) NOT NULL


I know to use concatenation, the collums have to defined as type CHAR/VARCHAR, but I don't have idea how to do this.
Some help is good.
Tks's

Delago - Brazil/SP
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Fri Sep 18, 2009 11:26 am
Reply with quote

Delago,
You can try this.

DIGITS(CAMPO_01)||DIGITS(CAMPO_02)
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

 


Similar Topics
Topic Forum Replies
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Exclude rows with > than x occurre... DFSORT/ICETOOL 6
No new posts Need Help with Packed Decimal Signs DFSORT/ICETOOL 4
No new posts Select a DB2 value in a specific deci... DB2 4
Search our Forums:

Back to Top