| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Doubt in Handling BLOB Messages |
« View previous topic :: View next topic » |
| Author |
Message
|
| vk |
 Posted: Fri Feb 10, 2006 5:14 am Post subject: |
 |
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
When the message comes directly from AS/400 system, in Compute node 2, the characters are unreadable. During database fetch, it returns zero rows.
I am throwing a user exception like - 'Query on table A using fields B and C returned zero rows'. In this the values shown for B and C, are unreadable. I am taking B and C from the message body after resetting the BLOB to MRM-TDS. Execution group trace also shows the entire body as unreadable. Here the CCSID is 37.
When I requeue the same message from the backout queue, the CCSID is changing to 817. In compute node 2, the fields B and C have proper values and so the query works fine and remaining code is also working as expected.
Does this have something to do with the CCSID? During development, when I put the message directly into the queue on AIX queue manager, the CCSID was 817. Only when the CCSID is 37, I found this issue. But when I do 'Copy Message Headers' in Compute node 1, all cases are working. I dont see any other issue in my code.
Thanks,
VK. |
|
| Back to top |
|
 |
| dsriksha |
| Posted: Fri Feb 10, 2006 8:27 am Post subject: |
|
|
Voyager
Joined: 27 Feb 2005
Posts: 95
|
Hi Vk ,
you doing database query based on messagebody or header?
I believe that it is based on Message body.
And it seems to be you sending message from AIX to AS/400 and processing replies from AS/400. If this is the case there is a ASCII and EBCDIC issue will raise. Obviously big thing with CCSIDs. |
|
| Back to top |
|
|
| vk |
| Posted: Fri Feb 10, 2006 8:59 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
I am doing the query based on message body.
My broker is in AIX for all environments.
In development, I put the message directly into the queue on AIX queue manager from MQ Explorer.
In test, the message comes from an application on AS/400. The AS/400 queue manager is in the same cluster as the AIX broker queue manager. There is no request - reply scenario.
Thanks,
VK. |
|
| Back to top |
|
|
| dsriksha |
| Posted: Fri Feb 10, 2006 9:08 am Post subject: |
|
|
Voyager
Joined: 27 Feb 2005
Posts: 95
|
Ok. However, I just want to know that you aware of things ASCII and EBCDIC that can be applied to AIX and AS/400 environments.
Believe me am not sure for any difference, if queuemanagers on cluster.  |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
