| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MessageSet Properties |
« View previous topic :: View next topic » |
| Author |
Message
|
| sachinramesh |
 Posted: Tue May 27, 2008 9:41 pm Post subject: MessageSet Properties |
 |
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
Hi
I had a tds message seperated by semicolon which looks like
fileds : sno;sname;place
values look like: 123;john;india,usa,uk,france
In my message set i wanted to split the values in the "place" field which are seperated by
comma(,)
I tried like this
created a def file which looks like
message : Row_details
Local elements:Row_records in which i added a new complex type and the local elements "sno" and "sname"
I had again created another local element "PLACE" and added a new complex type .
i got stuck up here bcos i could not add the local eelments under ths PLACE element ,as i dont know with how many values the field "Place" is coming with.
I think i am not going in the right way can anybody tell me how to do it or can u give me any siutable docs related to mset properties. |
|
| Back to top |
|
 |
| kimbert |
| Posted: Wed May 28, 2008 1:20 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| i could not add the local eelments under ths PLACE element ,as i dont know with how many values the field "Place" is coming with. |
You do not need local elements. What you need is one element which repeats.
- Add a single local element to 'Place'. Call it 'country'.
- Set maxOccurs to -1 on 'country'.
- in the TDS properties of 'country', set Repeating Element Delimiter to comma (,).
- On the complex type of Place, set Data Element Separation to 'All Elements Delimited'. You can set the delimiter to anything you like - it will never be used because Place only has one child element.
In the message tree, you will get a single element 'Place' with multiple child elements 'country'. |
|
| 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
|
|
|
|
