| Author |
Message
|
| satyasheel15 |
 Posted: Thu Jun 26, 2003 9:10 pm Post subject: Informwation wanted regarding BLOB |
 |
|
Voyager
Joined: 04 Mar 2003
Posts: 86
|
Hi I need some information.
For example, my input message is :
<XML><NAME>XYZ</NAME><AGE>24</AGE></XML>
And I want my output message as
<DETAIL><XML><NAME>XYZ</NAME><AGE>24</AGE></XML></DETAIL>
or
<DETAIL><XML><NAME>XYZ</NAME><AGE>24</AGE></XML>
I have written my ESQL code as:
SET "OutputRoot"."BLOB"."BLOB" = CAST('<DETAIL>' AS BLOB) || "InputRoot"."BLOB"."BLOB" || CAST('</DETAIL>' AS BLOB) ;
And I have set the Message Domain to BLOB.
Please let me know is this correct. If not, please provide me alternative solution.
Regards Always
Satyasheel |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Jun 26, 2003 9:49 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
What is your input message type? XML?
I think the following code should work for input XML domain:
| Code: |
SET OutputRoot.XML.DETAIL = InputRoot.XML;
|
_________________
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 |
|
|
| satyasheel15 |
| Posted: Fri Jun 27, 2003 6:30 am Post subject: Information Wanted Regarding BLOB |
|
|
Voyager
Joined: 04 Mar 2003
Posts: 86
|
Hi,
My input message is <XML><NAME>XYZ</NAME><AGE>24</AGE></XML>
and that comes as a BLOB [MessageDomain].
And I want output and that too as BLOB with the tag added as:
<Detail><XML><NAME>XYZ</NAME><AGE>24</AGE></XML></Detail>
OR
<Detail><XML><NAME>XYZ</NAME><AGE>24</AGE></XML>.
Please suggest some solution.
Regards Always
Satyasheel |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jun 27, 2003 7:00 am Post subject: Re: Information Wanted Regarding BLOB |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| satyasheel15 wrote: |
Hi,
My input message is <XML><NAME>XYZ</NAME><AGE>24</AGE></XML>
and that comes as a BLOB [MessageDomain].
And I want output and that too as BLOB with the tag added as:
<Detail><XML><NAME>XYZ</NAME><AGE>24</AGE></XML></Detail>
OR
<Detail><XML><NAME>XYZ</NAME><AGE>24</AGE></XML>.
Please suggest some solution. |
The code you put in your first message appears like it would work. Did you try it? Did you get an error, or the wrong result?
But the question that remains is why you want to work with XML data in the BLOB domain?
As Kirani said, you can do what you want at least as easily by working with your data in the XML domain instead. |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Jun 27, 2003 7:20 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Satyasheel,
If using BLOB domain, your code should look like this:
| Code: |
SET "OutputRoot"."BLOB"."BLOB" = CAST('<DETAIL>' AS BLOB CCSID InputRoot.Properties.CodedCharSetId) || "InputRoot"."BLOB"."BLOB" || CAST('</DETAIL>' AS BLOB CCSID InputRoot.Properties.CodedCharSetId) ;
|
_________________
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 |
|
|
| satyasheel15 |
| Posted: Fri Jun 27, 2003 7:21 am Post subject: Information wanted Regarding BLOB |
|
|
Voyager
Joined: 04 Mar 2003
Posts: 86
|
Hi,
Thanks for the fast response.
We have to try for XML as its our project requirement. I have written the code:
SET "OutputRoot"."BLOB"."BLOB" = CAST('<DETAIL>' AS BLOB) || "InputRoot"."BLOB"."BLOB" ;
But this code is not working and its going to the compute node fail. So please help me in that. |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Jun 27, 2003 7:29 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Did you try the code listed in my earlier post?
_________________
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 |
|
|
| satyasheel15 |
| Posted: Fri Jun 27, 2003 8:47 pm Post subject: Information wanted regarding BLOB |
|
|
Voyager
Joined: 04 Mar 2003
Posts: 86
|
Dear Mr. Kirani,
The code suggested by you works fine. I just didn't add
CAST ('<Details> AS BLOB CCSID InputRoot.Properties.CodedCharSetId).
I request you to please explain me what do you mean by :
" CCSID InputRoot.Properties.CodedCharSetId "
means. Can you please explain this particular portion of code.
Regards Always
Satyasheel |
|
| Back to top |
|
|
| kirani |
| Posted: Sun Jun 29, 2003 8:05 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
In above code CCSID option is converting the char string into BLOB format.
This option can be used for certain conversion only.
_________________
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 |
|
|
| satyasheel15 |
| Posted: Sun Jun 29, 2003 9:03 pm Post subject: Information Regarding BLOB |
|
|
Voyager
Joined: 04 Mar 2003
Posts: 86
|
Dear Mr. Kiran,
Thanks for your help and I understand your reply.
So please tell me whenever I have to convert Character to BLOB, I have to use this command:
CAST('<DTLS>' AS BLOB CCSID InputRoot.Properties.CodedCharSetId)
What is significance of InputRoot.Properties.CodedCharSetId ?
Can you please tell me from where I will get the information about the points which you have mentioned to me such as CCSID transformation etc. Is there any document available where I will such type of information.Please advise
Regards Always
Satyasheel |
|
| Back to top |
|
|
| kirani |
| Posted: Sun Jun 29, 2003 9:49 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
InputRoot.Properties.CodedCharSetId is the CCSID of your input message. You might want to use this CCSID when using CAST .. CCSID function. You can also specify different CCSID to get BLOB for different Character Set. For Example,
CAST(' ' CCSID Your_ASCII_CCSID) will return X'20' in ASCII character set.
CAST(' ' CCSID Your_EBCDIC_CCSID) will return X'40' in EBCDIC character set.
These options are documented in ESQL Reference manual.
_________________
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 |
|
|
| satyasheel15 |
| Posted: Mon Jun 30, 2003 12:14 am Post subject: Information Regarding BLOB |
|
|
Voyager
Joined: 04 Mar 2003
Posts: 86
|
Dear Mr. Kirani,
Thanks for your help and instant reply. Your code do works and I was getting the desired result. |
|
| Back to top |
|
|
|
|
