| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problems in CASTING |
« View previous topic :: View next topic » |
| Author |
Message
|
| tom_123 |
 Posted: Fri Mar 14, 2008 7:22 am Post subject: Problems in CASTING |
 |
|
Novice
Joined: 28 Feb 2008
Posts: 15
|
Hi,
Can anybody identify where is wrong in my code
(REPLACE (refDrr.DBRH_REC.DTRB.ValueCreditTransfersDirect,',','.')) + (REPLACE (refDrr.DBRH_REC.DTRB.ValueCreditTransfersIndirect,',','.'))
I want to add these values. where in data type of refDrr.DBRH_REC.DTRB.ValueCreditTransfersDirect and refDrr.DBRH_REC.DTRB[I].ValueCreditTransfersIndirect is CHARACTER.
When i trying to deploy "Invalid or incompatible data types for '+' operator" error I get.
I also try in using CAST
"CAST(REPLACE (refDrr.DBRH_REC.DTRB.ValueCreditTransfersDirect,',','.')) AS DECIMAL) + CAST(REPLACE (refDrr.DBRH_REC.DTRB.ValueCreditTransfersIndirect,',','.')) AS DECIMAL)"
but I still getting error in toolkit.
I want to know where I wrong. |
|
| Back to top |
|
 |
| mrgate |
| Posted: Fri Mar 14, 2008 7:35 am Post subject: |
|
|
Centurion
Joined: 28 Feb 2007
Posts: 141
Location: India
|
Hello tom_123,
can you post a sample input structure.
_________________
MQSeries terrorist |
|
| Back to top |
|
|
| tom_123 |
| Posted: Fri Mar 14, 2008 7:51 am Post subject: |
|
|
Novice
Joined: 28 Feb 2008
Posts: 15
|
Hi,
Message in field is in format "000000000001024,00" and "000000000000000,00" which is in character.
I want to add these values and store in another field which data type also in character. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
