| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Is it possible to remove nulls from message with MRM ? |
« View previous topic :: View next topic » |
| Author |
Message
|
| MVO |
 Posted: Mon Jan 10, 2005 10:47 am Post subject: Is it possible to remove nulls from message with MRM ? |
 |
|
Centurion
Joined: 09 Sep 2001
Posts: 131
|
Hi,
We're running WMQI 2.1 CSD06
We were using NEON & are converting to MRM. The broker can receive messages containing nulls anywhere in the message text. I notice that the nulls are automatically removed by NEON but are retained with MRM. This is casuing us problem when we're sending the message out in XML format, the receiver cannot read it because of the nulls.
Is there any easy way to have MRM behaving the same way as NEON concerning nulls i.e. to remove them during parsing ?
Thanks |
|
| Back to top |
|
 |
| shanson |
| Posted: Tue Jan 25, 2005 5:05 am Post subject: |
|
|
Partisan
Joined: 17 Oct 2003
Posts: 344
Location: IBM Hursley
|
It depends what you mean by nulls, and what physical format your messages are using:
- If you mean detect that a field has the logical meaning 'null' then you can use 'Encoding Null' support in the MRM
- If you mean null (x00) chars on the end of strings you can get these stripped by specifying NUL as the padding character. |
|
| Back to top |
|
|
| MVO |
| Posted: Tue Jan 25, 2005 10:00 am Post subject: |
|
|
Centurion
Joined: 09 Sep 2001
Posts: 131
|
| Thanks for your reply but I have nulls in the middle of the text stream and want to have them removed. I can define a repetitive string each with NULL terminator but I'm looking for a more elegant solution. |
|
| Back to top |
|
|
| JT |
| Posted: Tue Jan 25, 2005 10:58 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Take a look at the REPLACE function.
| Code: |
| REPLACE(InputRoot."BLOB"."BLOB", x'00'); |
| Quote: |
| If you do not specify the replace string expression, the replace string defaults to an empty string and the behavior of the function is to delete all occurrences of the search string from the result. |
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
