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