| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| BLOB |
« View previous topic :: View next topic » |
| Author |
Message
|
| dsmq |
 Posted: Mon Sep 16, 2002 9:05 am Post subject: BLOB |
 |
|
Acolyte
Joined: 20 Jun 2002
Posts: 59
|
i am reading my input message as blob .After that i want to take the substring of that. How do i do this
I am using
DECLARE MSG CHAR;
SET MSG = CAST(SUBSTRING(InputBody."BLOB"."BLOB" FROM 10 FOR 2) AS CHAR CCSID 437)
But its not working.
can anybody help me in this
Thanks |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Sep 16, 2002 9:30 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Could you pl explain what exact problem you are having here? Are you getting a deploy error or are you getting different CHAR than expected or a runtime error?
Your BLOB message will come in as .. X'2382283838...'. Pl make sure you are specifying the correct position in your code.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
Last edited by kirani on Mon Sep 16, 2002 10:03 am; edited 1 time in total |
|
| Back to top |
|
|
| dsmq |
| Posted: Mon Sep 16, 2002 9:39 am Post subject: BLOB |
|
|
Acolyte
Joined: 20 Jun 2002
Posts: 59
|
Kiran
Thanks for u r reply
my input message is
LLZZres01p50 12000099PGEN res01p50FFFFFFFFXCND7b5 iam reading this message as BLOB
i want to get the 10 th position upto 12 th position.
Could u pls tell me how do i go about this.
Regards |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Sep 16, 2002 10:02 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
CAST(SUBSTRING(InputRoot."BLOB"."BLOB" FROM 10 FOR 3) AS CHAR CCSID 437);
will return you p50. Is this is what you want?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| dsmq |
| Posted: Mon Sep 16, 2002 11:40 am Post subject: BLOB |
|
|
Acolyte
Joined: 20 Jun 2002
Posts: 59
|
|
| 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
|
|
|
|
