| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| BLOB TO XML |
« View previous topic :: View next topic » |
| Author |
Message
|
| chez |
 Posted: Fri Feb 06, 2004 6:42 am Post subject: BLOB TO XML |
 |
|
Newbie
Joined: 06 Feb 2004
Posts: 1
|
I would like to convert a BLOB message to XML with repeating groups.
The content of the BLOB looks something like this
BLOB
ABC,05-02-04,1.7,34.5;DEF,01-02-04,8.9,23.5;GHI,23-02-04,23.7,12.8;
XML
<List>
<Valuation>
<Code>ABC</Code>
<Date>05-02-04</Date>
<Income>1.7</Income>
<Capital>34.5</Capital>
</Valuation>
<Valuation>
<Code>DEF</Code>
<Date>01-02-04</Date>
<Income>8.9</Income>
<Capital>23.5</Capital>
</Valuation>
<Valuation>
<Code>GHI</Code>
<Date>23-02-04</Date>
<Income>23.7</Income>
<Capital>12.8</Capital>
</Valuation>
</List>
Is this possible? |
|
| Back to top |
|
 |
| EddieA |
| Posted: Fri Feb 06, 2004 9:34 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Why does it have to be a BLOB. That message looks a perfect candidate for a TDS.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| kspranava |
| Posted: Sun Feb 08, 2004 6:25 pm Post subject: TDS is very good option |
|
|
Centurion
Joined: 27 Apr 2003
Posts: 124
|
Hi,
TDS is a very good way of doing it. Still, if u want it to be done through ESQL u can always do it. All you have to do is, do the operations in blob format and then convert it to a XML using RCD node. While doing operations in BLOB u shud use hex codes instead alphanumerics.
i/p node -> compute node --> RCD --> o/p node.
Pranava. |
|
| Back to top |
|
|
| kimbert |
| Posted: Mon Feb 09, 2004 1:46 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| I agree with Eddie. Use TDS unless you have a very good reason not to. |
|
| 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
|
|
|
|
