| Author |
Message
|
| kumar.shanj |
 Posted: Mon Jan 24, 2011 2:11 am Post subject: How to correct special character in esql in message broker? |
 |
|
Apprentice
Joined: 18 Nov 2010
Posts: 49
|
I am getting special character value from the values retrieved from database attributes,which is being passed to message set to get output file as comma seperated value.
As of now i am setting message set preoperties like mentioned below.
/* Set Message Properties*/
SET OutputRoot.Properties.MessageDomain = 'MRM';
SET OutputRoot.Properties.MessageFormat = 'TDS1';
SET OutputRoot.Properties.MessageSet = 'I119R18002001';
SET OutputRoot.Properties.MessageType = 'OrbitFeedToAMSMessage';
/* Set RFH2 header fields */
SET OutputRoot.MQRFH2.(MQRFH2.Field)Format = 'MQSTR ';
SET OutputRoot.MQRFH2.mcd.Msd = 'mrm';
SET OutputRoot.MQRFH2.(MQRFH2.Field)NameValueCCSID = 1208;
SET OutputRoot.MQRFH2.(MQRFH2.Field)CodedCharSetId = 1208;
In the output data generated in file, i am seeing a special character like "_|" in few values.
Please help me in resolving this problem |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Jan 24, 2011 5:24 am Post subject: Re: How to correct special character in esql in message brok |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kumar.shanj wrote: |
| Please help me in resolving this problem |
Output the file in a code page that supports all the special characters.
Assuming the target box (the one onto which the file is being written) has such a code page.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Jan 24, 2011 5:32 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Given that codepage 1208 is capable of supporting all characters, I'd be more tempted to confirm that the database has saved the characters correctly in the first place and that they aren't being mangled in retrieval either.. |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Jan 24, 2011 5:35 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| Given that codepage 1208 is capable of supporting all characters |
Isn't that just the CCSID of the name value pairs in the RFH2 rather than the message? Or have I just not had enough coffee this morning?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Jan 24, 2011 5:38 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The CCSID on the MQRFH2 indicates the CCSID of the next section of the message.
And, yes, you need more coffee. |
|
| Back to top |
|
|
|
|
