| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Help on defining message set |
« View previous topic :: View next topic » |
| Author |
Message
|
| Mohit Gupta |
 Posted: Wed Nov 10, 2004 1:37 am Post subject: Help on defining message set |
 |
|
Apprentice
Joined: 16 Sep 2004
Posts: 34
|
Hi ,
If i have an incoming message in the CSV format
e.g. 1000,FK,2004,06,08/06/04,02/07/04,1328456AUD,AUD,3106,AUD,135937.2,135937.2,135937.2,135937.2,,,,
1000,FK,2004,06,08/06/04,02/07/04,2113360AUD,AUD,3106,AUD,-135937.2,-135937.2,-135937.2,-135937.2,,,,
....
....
and i want to work by using XML domain and i would like the data in xml format like this...
<File>
<RowSet setType="Managed">
<Row>
<Company>1000</Company>
<Currency>USD</Currency>
....
....
</Row>
<Row>
<Company>1000</Company>
<Currency>USD</Currency>
....
....
</Row>
......
......
</RowSet>
<RowSet setType="UnManaged">
<Row>
<Company>2000</Company>
<Currency>USD</Currency>
....
....
</Row>
<Row>
<Company>2000</Company>
<Currency>USD</Currency>
....
....
</Row>
......
......
</RowSet>
<RowSet setType="Managed">
<Row>
<Company>1000</Company>
<Currency>USD</Currency>
....
....
</Row>
<Row>
<Company>1000</Company>
<Currency>USD</Currency>
....
....
</Row>
......
......
</RowSet>
.........
.........
</File>
So how do i create my message definition....whenever i tried to add attribute on RowSet i got an error Attribute cannot be defined on the All Elements Delimited set.
Please help me how to achieve such a message format
Cheers,
Mohit Gupta |
|
| Back to top |
|
 |
| kimbert |
| Posted: Wed Nov 10, 2004 3:42 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Define the members of RowSet as elements, instead of as attributes. On the XML physical properties for each element, set the 'Render' property to 'Attribute'. |
|
| Back to top |
|
|
| Mohit Gupta |
| Posted: Wed Nov 10, 2004 5:13 am Post subject: |
|
|
Apprentice
Joined: 16 Sep 2004
Posts: 34
|
| Thanks a lot for the help ! |
|
| 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
|
|
|
|
