| Author |
Message
|
| Adi3 |
 Posted: Wed Dec 20, 2006 9:40 am Post subject: CodedCharSetId Values |
 |
|
Novice
Joined: 19 Dec 2006
Posts: 15
|
Where can I get the details and list of CodedCharSetId?
For eg:
Which CodedCharSetId I should use for different applications like Mainframe, Solaris etc. |
|
| Back to top |
|
 |
| JosephGramig |
| Posted: Wed Dec 20, 2006 10:44 am Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
|
| Back to top |
|
|
| Adi3 |
| Posted: Wed Dec 20, 2006 11:52 am Post subject: |
|
|
Novice
Joined: 19 Dec 2006
Posts: 15
|
In ESQL program I have the following line:
SET OutputRoot.MQMD.CodedCharSetId = 37;
I would like to know for which system this Id is mentioned.
By seeing the value, I would like to know the type of system or why that particular Id is used. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Dec 20, 2006 12:11 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You should only ever set the CCSID to the one that is appropriate for the data that you have put into the message.
This should never be dependent on who is going to receive the data.
NEVER.
DO NOT DO THIS.
It is the job of the receiving application to know how to handle the CCSID that you have populated, or ask MQ to convert the data into a CCSID that the receiver can handle, or perform the conversion directly.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Adi3 |
| Posted: Wed Dec 20, 2006 12:45 pm Post subject: |
|
|
Novice
Joined: 19 Dec 2006
Posts: 15
|
Thanks for your answer.
Actually my question is different.
"You should only ever set the CCSID to the one that is appropriate for the data that you have put into the message."
Yes its Perfect.
I would like to know how to determine the CCSID value for a particular type of data and where can I get those details.
Actually I have set of message flows developed already by someone. I'm trying to understand the program. In that I could see the different CCSID values. From that I would like to know how the particular value is determined in the program like 37, 1208 etc. appropriate for the data which is put into the message. |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Wed Dec 20, 2006 1:46 pm Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
most likely the 37 is an error and should have been 437 for Windows. 1208 is unicode (JMS).
_________________
Joseph
Administrator - IBM WebSphere MQ (WMQ) V6.0, IBM WebSphere Message Broker (WMB) V6.1 & V6.0
Solution Designer - WMQ V6.0
Solution Developer - WMB V6.1 & V6.0, WMQ V5.3 |
|
| Back to top |
|
|
| gilbert |
| Posted: Thu Dec 21, 2006 12:47 am Post subject: |
|
|
Novice
Joined: 31 Oct 2006
Posts: 14
|
| Take into account also the CCSID of QueueManager. Especially if you are using pub/sub. |
|
| Back to top |
|
|
| Nigelg |
| Posted: Thu Dec 21, 2006 1:21 am Post subject: |
|
|
Grand Master
Joined: 02 Aug 2004
Posts: 1046
|
The CCSID of a msg is by default the CCSID of the qmgr. In turn, this is determined from the machine locale when the qmgr was created, but it can be altered after qmgr creation. See the APR Data Conversion appendices for details.
37 is not a typo, it is the default English CCSID on iSeries. It closely resembles other EBCDIC codepages, e.g. 500 on zOS.
_________________
MQSeries.net helps those who help themselves.. |
|
| Back to top |
|
|
| gilbert |
| Posted: Thu Dec 21, 2006 7:00 am Post subject: |
|
|
Novice
Joined: 31 Oct 2006
Posts: 14
|
| If you use JMS pub/sub then when message is published to a topic it is transformed according to Qmgr's CCSID which can mess up special characters. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Dec 21, 2006 2:23 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| JosephGramig wrote: |
| most likely the 37 is an error and should have been 437 for Windows. 1208 is unicode (JMS). |
CCSID 37 = EBCDIC English
CCSID 500 = EBCDIC English international...
CCSID 1208 = UTF-8
Etc...
Now that you know what it is please follow jeff's advice.!! 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| killer |
| Posted: Thu Dec 21, 2006 3:39 pm Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 35
|
|
| Back to top |
|
|
| wschutz |
| Posted: Thu Dec 21, 2006 3:50 pm Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
| killer |
| Posted: Thu Dec 21, 2006 4:08 pm Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 35
|
Hey wschutz,
Thanks a lot.This what the fourm is for sharing of knowledge and the links
Truly speaking,
It's really good and helpful. |
|
| Back to top |
|
|
| Adi3 |
| Posted: Fri Dec 22, 2006 8:49 am Post subject: |
|
|
Novice
Joined: 19 Dec 2006
Posts: 15
|
| Thank you very much wschutz, This is what I was expecting and atlast I got it. |
|
| Back to top |
|
|
|
|
