| Author |
Message
|
| rohank84 |
 Posted: Thu Feb 12, 2009 5:17 am Post subject: Complete XML String |
 |
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
hi i have a following flow
fileinput -->compute1 -->resetcontentDescriptor -->compute2 -->MQOutput
here in fileinput node the domain is BLOB and i set the domain to MRM in resetcontentdescriptor. I have specified the message set and everything in resetcontentdescriptor property. In compute2 node i set the output root property to XML using this statement
| Code: |
SET OutputRoot.Properties.MessageFormat = 'XML';
|
and i get the output as XML in MQOutput. This is working fine ....
The problem is that i have to insert this XML string into Database in compute2 node . So i need to know how can I get this XML string.
the Database field type is CLOB.... |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Feb 12, 2009 5:22 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| So, you want your message data as a stream of bits? |
|
| Back to top |
|
|
| rohank84 |
| Posted: Thu Feb 12, 2009 5:27 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
| yes...jeff ...the resetcontentdescriptor converts the blob input into XML so need the converted XML ..... |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Feb 12, 2009 5:52 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| So, you want your message data as a stream of bits? |
I suspect this is connected to this post where the entire project, inexplicably, is in BLOB.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Thu Feb 12, 2009 5:55 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
| no vitor ...this is a different project ..... |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Feb 12, 2009 5:58 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| no vitor ...this is a different project ..... |
And yet you're reducing message trees to mere streams of bytes again...  
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Thu Feb 12, 2009 6:03 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
i didnt get you vitor ....im pretty new to WMB....s
i need to insert the XML in Database ...im sure that RCD converts the incoming blob to XML as I am able to get the XML in MQoutput.... |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Feb 12, 2009 6:49 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| i didnt get you vitor ....im pretty new to WMB....s |
As you correctly pointed out in your previous thread, I have no influence over your project requirements, nor the decision of your site to ignore product features and do things the hard way.
I apologise if you found my comment unwarrented. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Feb 12, 2009 7:04 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
If you were trying to do this with a Java Compute node, you would use the toBitstream() method on the MbElement that represented the root of your message tree.
Since you are using ESQL, you must use a different function. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Thu Feb 12, 2009 9:29 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
hi jeff ....which method u are saying to use ...please elaborate ....thanks
hi vitor saying it again as i mentioned in my previous post if u have a the solution then you can tell me ...
I apologise if you found my comment unwarrented.
your efforts will definatey be appreciated..... |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Feb 12, 2009 9:54 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| rohank84 wrote: |
| hi jeff ....which method u are saying to use ...please elaborate ....thanks |
No. I will not elaborate.
This is a basic question that requires a bare minimum of effort on your part.
 |
|
| Back to top |
|
|
| rohank84 |
| Posted: Thu Feb 12, 2009 10:38 pm Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
| hi jeff ...i tried putting the OutputRoot in the Database but its empty....i know i can fetch data through XML tags ...sorry but here i need the whole XML message ...im using a message set ...so how can i come to know the tags that are there in the developed XML...... |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 13, 2009 1:18 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| hi jeff ...i tried putting the OutputRoot in the Database but its empty....i know i can fetch data through XML tags ...sorry but here i need the whole XML message ...im using a message set ...so how can i come to know the tags that are there in the developed XML...... |
We are not a training resource.
We are not here to summarise the documentation for you.
We are not here to write your code for you.
Use the suggestion given a few posts back. You'll find details in the documentation (which actually describes a scenario like this; I've just checked).
If you then have a specific question on how to do this, rather than a general "I tried something and it didn't work please help" then we will be glad to respond.
Specific questions do not look like:
| Quote: |
| ...i tried putting the OutputRoot in the Database but its empty |
but contain the code in question, the input, the output and the design reasoning behind coding it that way.Not "well I hadn't tried that yet so I gave it a spin", as one of my underlings said yesterday.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Fri Feb 13, 2009 1:44 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
hi
this is the XML which is generated ...
| Code: |
| <?xml version="1.0"?><!DOCTYPE MRM PUBLIC "DQADLGC0VG001" "www.mrmnames.net/DQADLGC0VG001"><MRM xmlns="www.mrmnames.net/DQADLGC0VG001"><SwiftEnvelope><FIN_ACK_NAK><SWBH><LT_Identifier>FDRLINBBAIBD</LT_Identifier><Session_Number>190</Session_Number><Sequence_Number>5604</Sequence_Number></SWBH><FIN_ACKNAK_TEXT><SW177><DATE>2009-01-12T00:00:00+05:30</DATE><TIME>1970-01-01T09:33:00+05:30</TIME></SW177><SW451>0</SW451></FIN_ACKNAK_TEXT></FIN_ACK_NAK><FIN><SWBH><LT_Identifier>FDRLINBBAIBD</LT_Identifier><Session_Number>190</Session_Number><Sequence_Number>5604</Sequence_Number></SWBH><FIN_OUTPUT_SWAH><Message_Type>103</Message_Type><Input_Time>1970-01-01T09:33:00+05:30</Input_Time><MIR>090112FDRLSTPPKEOM0190005604</MIR><Output_Date>2009-01-12T00:00:00+05:30</Output_Date><Output_Time>1970-01-01T09:33:00+05:30</Output_Time><Message_Priority>N</Message_Priority></FIN_OUTPUT_SWAH><TEXT_BLOCK><MT103><SW20>120004887</SW20><SW23B>CRED</SW23B><SW32A><DATE>2009-01-11T00:00:00+05:30</DATE><CURRENCY>I |
the input here is a BLOB msg which is converted into XML using RCD node wherein the message sets are defined ....i get the generated XML in MQOutput....mentioned above.....
please tell how to do this... |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 13, 2009 1:54 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| please tell how to do this... |
No.
See comments above.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
