Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
Your mrm message definition doesn't match with your ESQL code. Here is what you should do:
1. Create a type element (repeat_element_type).
2. Add field1 and field2 into this type element.
3. Create an element by name repeat_element of type repeat_element_type.
4. Create a new message and add elements: ValCount, repeat_element into it.
5. In connection tab, set repeat to yes for repeat_element.
6. In CWF tab, set repeat type to valueOf valCount.
7. Checkin your message and do a complete deploy of the messageset.
Once this message is created, use the esql code that I posted earlier for transformation. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
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