| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| problem in transformation |
« View previous topic :: View next topic » |
| Author |
Message
|
| elvis_gn |
 Posted: Fri Feb 10, 2006 1:52 am Post subject: |
 |
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi praveenraju,
The value in BTPckId is a string(CHARACTER)...
You are trying to add an integer to it.
Untested code
| Code: |
| SET OutputRoot.XML.rootx.sr.crf.BTPckId=CAST(CAST(InputRoot.XML.rootx.sr.crf.BTPckId AS INTEGER) + 100 AS CHARACTER); |
Regards. |
|
| Back to top |
|
 |
| fschofer |
| Posted: Fri Feb 10, 2006 1:59 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
additionel use
XML.rootx.sr.BTPckId instead of XML.rootx.sr.crf.BTPckId
Greetings
Frank |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Feb 10, 2006 2:07 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
fschofer:
Thanks missed that 
praveenraju:
Please please, pick up the ESQL pdf and simply read through the commands... 
We cannot be taking you through your entire learning curve.
Regards. |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Feb 10, 2006 2:34 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
But you don't need to use a CAST at all, and if you do it will be slower. In your case an implicit cast will be done for you automatically. Your problem was simply that you were using the wrong field name as fschofer pointed out.
However, your code also did:
| Quote: |
CALL CopyMessageHeaders();
SET OutputRoot=InputRoot; |
And you do not need to do both, because SET OutputRoot = InputRoot copies the headers as well as the body. Therefore, the CALL to CopyMessageHeaders is a waste of time.
Regards,
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| 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
|
|
|
|
