| Author |
Message
|
| rohank84 |
 Posted: Fri Feb 13, 2009 1:56 am Post subject: |
 |
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
| what else do u wnt to know vitor ..... |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Feb 13, 2009 2:02 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| what else do u wnt to know vitor ..... |
How it's going with the ESQL manual, what your code looks like, what your thinking behind it is, what you expected to happen and why.
I'll accept that you didn't post the output because in this instance there is no output.
I'll also repeat, slightly off topic, my interest in your site's attachment to the BLOB domain which is somewhat unusual. And counter productive.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Fri Feb 13, 2009 2:21 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
vitor u are absolutely write that BLOB domain is counter productive.
| Quote: |
| what your code looks like, what your thinking behind it is, what you expected to happen and why |
here as i said blob is converted to XML using RCD node where the messase type is MRM and a message set is defined ....
the flow looks like this
FileInput (text file) -->Compute-->RCD-->Compute1-->MQOutput
in the first Compute node i fetch the Blob data and insert into database...in the second compute node the same data have to be inserted into database as a XML string ....at the MQoutput node i get the XML string which i posted in the previous post ....so the output is correct the way i want it to be .....
| Quote: |
| How it's going with the ESQL manual |
its going good but im not familiar with the basic fundamentals.....so face problem in understanding things.....otherwise the pdf is really very good...i have developed few flows using the manual |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 13, 2009 2:27 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| im not familiar with the basic fundamentals.....so face problem in understanding things |
Then you so need some formal training. As I said before, the forum is not a training resource. We're just not set up for it.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Fri Feb 13, 2009 2:33 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
yah u are absolutely write forums are not for training ....but cnt do much in this i have to complete the work anyhow....though im reading various PDF so i guess things will improve in coming months ....and i will start helping people rather than asking ..  |
|
| Back to top |
|
|
| rohank84 |
| Posted: Fri Feb 13, 2009 3:52 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
| any1 knows how to do this ... |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 13, 2009 3:55 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| but cnt do much in this i have to complete the work anyhow |
And next time? Another posting to the forum when you get stuck? And another? And another?
If you don't understand the basic fundamentals (as you put it), you're just going to keep struggling. You need to push back and obtain training.
It's like me trying to write Java.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Feb 13, 2009 4:22 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Specifically what you need to do to solve this particular problem is read the through the ESQL reference and find the name of an ESQL statement,function, or operator that appears to be similar in nature to the Java method of the MbElement class called "toBitstream".
It would be instructional for you, as well, to see if you can find the definition of the "toBistream" method on the MbElement class in the Java references in the Message Broker documentation.
I prefer using the InfoCenter rather than using the PDFs because I find it more oraganized by topic and I only have to look in one place rather than several PDFs to find information, but I know several other people here prefer the PDFs. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Sun Feb 15, 2009 11:26 pm Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
Hi jeff ....i tried using ASBITSTREAM function and got my message in BLOB type.... now i need to convert this into XML message
| Code: |
set inputmessage = ASBITSTREAM(InputRoot); |
....i read few posts which says to use RCD node...is there any method to convert the BLOB in XML without RCD node....... |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Feb 16, 2009 5:24 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20767
Location: LI,NY
|
Moved to correct forum 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Mon Feb 16, 2009 5:51 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| rohank84 wrote: |
Hi jeff ....i tried using ASBITSTREAM function and got my message in BLOB type.... now i need to convert this into XML message
| Code: |
set inputmessage = ASBITSTREAM(InputRoot); |
|
The CAST function is sometimes useful, for converting a BLOB to CHARACTER. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Tue Feb 17, 2009 2:56 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
hi rekarm01
here i dnt need to convert to character ...i need to convert this BLOB to XML ...... |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Feb 17, 2009 3:16 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Having just spent all this time and energy figuring out how to turn the XML into a BLOB, why do you possibly think you need to turn it BACK into XML?
Stop wasting your own time and start reading, thinking, trying and learning. |
|
| Back to top |
|
|
| WMB_User |
| Posted: Tue Feb 17, 2009 7:23 am Post subject: |
|
|
Apprentice
Joined: 17 Nov 2008
Posts: 31
|
| Quote: |
| in the first Compute node i fetch the Blob data and insert into database...in the second compute node the same data have to be inserted into database as a XML string . |
Using the CAST function will do what you wish, convert the BLOB to an "XML string". |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 17, 2009 7:27 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| WMB_User wrote: |
| Using the CAST function will do what you wish |
No it won't - see above!
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
