| Author |
Message
|
| raghav129 |
 Posted: Wed May 14, 2008 12:59 am Post subject: EBCDIC format to a character format in Message Broker |
 |
|
Novice
Joined: 30 Aug 2007
Posts: 17
|
Hello,
How can I convert EBCDIC format to a character format inside Message broker?
Any ideas/suggestions would be gratefaul, |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed May 14, 2008 1:12 am Post subject: Re: EBCDIC format to a character format in Message Broker |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| raghav129 wrote: |
How can I convert EBCDIC format to a character format inside Message broker?
|
EBCDIC is character! 
If you're receiving messages from z/OS onto an ASCII platform, ensure the code page conversion is set up properly. This is WMQ, not WMB.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| raghav129 |
| Posted: Wed May 14, 2008 1:38 am Post subject: |
|
|
Novice
Joined: 30 Aug 2007
Posts: 17
|
Many thanks for your reply,
How do we achieve that in MQ,
I am relatively new to MQ,so not sure how to setup this in MQ |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 14, 2008 1:45 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| raghav129 wrote: |
| I am relatively new to MQ,so not sure how to setup this in MQ |
- Get some training
- Ask whoever's administering the queue managers to ensure the code pages on the respective queue managers are set correctly
- Ensure conversion is enabled on the MQInput node
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed May 14, 2008 2:05 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
And if your message is text only make sure the sender sets
MQMD.FORMAT=MQC.MQFMT_STRING
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 14, 2008 2:11 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| fjb_saper wrote: |
MQMD.FORMAT=MQC.MQFMT_STRING
|
Every time I forget that. Every time! 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| raghav129 |
| Posted: Wed May 14, 2008 9:43 pm Post subject: |
|
|
Novice
Joined: 30 Aug 2007
Posts: 17
|
Thanks for your inputs
We were able to achieve this by using CAST function with right CCSID and Encoding value. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed May 14, 2008 11:26 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| raghav129 wrote: |
| We were able to achieve this by using CAST function with right CCSID and Encoding value. |
You should have been able to do this with the convert option as indicated.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| raghav129 |
| Posted: Thu May 15, 2008 2:53 am Post subject: |
|
|
Novice
Joined: 30 Aug 2007
Posts: 17
|
The convert option is unable to do that..
Not sure if the convert option of the MQInput Node has some problem.
Many of my team members are facing the same problem with the convert option. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu May 15, 2008 1:53 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| raghav129 wrote: |
Thanks for your inputs
We were able to achieve this by using CAST function with right CCSID and Encoding value. |
Should be even easier.
Model the data in a message set (import Cobol copy book).
On the Output.Properties.CodedCharSetId put the output CCSID 1208 (UTF-8 ) and send to MQOutput node. On the queue you will have a msg in UTF-8
Have fun
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
