Author |
Message
|
brgmo |
Posted: Tue Nov 13, 2007 2:37 am Post subject: How to convert xml to flat file structure |
|
|
Master
Joined: 03 Jun 2002 Posts: 227
|
Hi All,
I have a requirement wherein the input data is xml file.I have to create a flat file structure and embed it with the data contained int he input xml file. Any ideas how to do this.I am using 5.1.
Regards
brgmo. |
|
Back to top |
|
 |
Gaya3 |
Posted: Tue Nov 13, 2007 2:47 am Post subject: |
|
|
 Jedi
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
|
Hi
Just vice versa of this.......
http://www.mqseries.net/phpBB2/viewtopic.php?t=40478
1. Input message set (XML)
2. Output Message Set (TDS)
3. Code ESQL/Mapp
Regards
gayathri _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
Back to top |
|
 |
brgmo |
Posted: Tue Nov 13, 2007 2:58 am Post subject: |
|
|
Master
Joined: 03 Jun 2002 Posts: 227
|
Gaya3,i saw this one but i am using 5.1 and it doesn't have file extender node.Any idea how to do that without this. |
|
Back to top |
|
 |
AkankshA |
Posted: Tue Nov 13, 2007 3:04 am Post subject: |
|
|
 Grand Master
Joined: 12 Jan 2006 Posts: 1494 Location: Singapore
|
|
Back to top |
|
 |
brgmo |
Posted: Tue Nov 13, 2007 3:15 am Post subject: |
|
|
Master
Joined: 03 Jun 2002 Posts: 227
|
AkanshA,any idea how to convert the xml file to fla structure like the below:
BAC @@ DEF 123
I am a bit confused as how to do this because the message set is not required here like TDS etc. |
|
Back to top |
|
 |
brgmo |
Posted: Tue Nov 13, 2007 3:34 am Post subject: |
|
|
Master
Joined: 03 Jun 2002 Posts: 227
|
Can someone help me on this,please. |
|
Back to top |
|
 |
jefflowrey |
Posted: Tue Nov 13, 2007 3:34 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
You need to use plain broker methods to build the logical message tree in such a way that, when it is rendered into a physical bitstream, it will hold the data that you want in the format you need.
You then need to write this bitstream into a file.
These are entirely separate tasks. And are basic operations - one in Message Broker programming, and the other in any programming.
There are many many discussions of all of the options for taking a logical message tree in Broker and writing it into a file. All of these choices require that you spend money - either in the form of buying an add on to Broker v5, buying an additional product, or in the time and people skills necessary to write it yourself. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
|