Posted: Sat Jun 05, 2004 10:28 pm Post subject: MQInput node character conversion
Newbie
Joined: 04 Jun 2004 Posts: 4
I know that I can specify conversion settings in MQinput that will convert my charset to whatever.
But someone told me to also change the MQMD elements e.g.
SET OutputRoot.MQMD.Encoding = ?;
SET OutputRoot.MQMD.CodedCharSetId = ?;
Can someone explain if and why I also need to set the MQMD elements?
Also, I have been informed that looking at my charset using a trace dump inside the flow doesnt matter since its just utf-8 and thus i need to look at the output queue since its only when the message is put there that it has the right charset that i want (the one specified in the mqinput)?
Joined: 17 Oct 2003 Posts: 344 Location: IBM Hursley
I think you are getting two things mixed up. The MQInput conversion options apply to converting the input message. Setting the output message MQMD properties affect the output message.
MQSeries data conversion should not need to be used because the broker itself, and not MQSeries, does the data conversion automatically when the input data is parsed. This results in a message tree where string data is in Unicode (not UTF-8 btw). On output the Unicode is converted into the code page specified by the output message.
Also note that it is more usual to set the Properties folder CCSID and encoding fields rather than the MQMD folder fields.
If you do really want to manipulate your string data in a message flow in a particular code page rather than as Unicode, you need to create a blob variable and CAST the string value into a blob specifying the target code page - this will take the Unicode, data convert to the code page, and give you it as raw binary.
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