|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
Problem Mapping repeating structure |
« View previous topic :: View next topic » |
Author |
Message
|
sieijish |
Posted: Thu Dec 16, 2004 2:41 pm Post subject: Problem Mapping repeating structure |
|
|
Acolyte
Joined: 29 Nov 2004 Posts: 67 Location: London
|
Hi all,
I am trying to map a repeating element (<event>) in source message "events" to a corresponding repeating element (<Levent>) in the target message "Levents".
<events>
<event text1="tA1" text2="tA2"/>
<event text1="tB1" text2="tB2"/>
</events>
<Levents>
<Levent ltext1="tA1" ltext2="tA2"/>
<Levent ltext1="tB1" ltext2="tB2"/>
</Levents>
I have two seperate message definitions, one for "events" & the other for "Levents". Both <event> & <Levent> elements are having max occurance of -1.
In the mapping node, when I have imported the source message as "events" and target as "Levents". In the 'events' tree I can see event[], event[all] & event[1]. In the 'Levents' tree of the target pane, i can see Levent[], Levent[all] & Levent[1]
I have mapped the fields text1, text2 under event[All] to the respective fields under Levent[All]
The Problem is that the output is generated as given below:-
<Levents>
<Levent ltext1="tA1"/>
<Levent ltext1="tB1"/>
<Levent ltext2="tA2"/>
<Levent ltext2="tB2"/>
</Levents>
I don't understand why <Levent> is repeated for each filed that I had mapped. Am I doing something wrong here? What is the right way of doing such a mapping? Please help..
Also, what is the use of Levent[] under the message tree?
Please help. |
|
Back to top |
|
 |
sieijish |
Posted: Fri Dec 17, 2004 2:22 am Post subject: |
|
|
Acolyte
Joined: 29 Nov 2004 Posts: 67 Location: London
|
Can anyone please give a reply to this? This is a bit urgent & I don't know how to proceed. |
|
Back to top |
|
 |
Ramphart |
Posted: Fri Dec 17, 2004 4:21 am Post subject: |
|
|
 Disciple
Joined: 21 Jul 2004 Posts: 150 Location: South Africa, JHB
|
|
Back to top |
|
 |
sieijish |
Posted: Mon Dec 20, 2004 2:44 am Post subject: Is this a bug in WBIMB version 5 |
|
|
Acolyte
Joined: 29 Nov 2004 Posts: 67 Location: London
|
In the Compose Mapping Expression window for the mapping of "text1" under event[] tree, I see the following.
mapping : text1 --> ltext1
value of target field: t_LLGEvents.event["#I"].ltext1
Repeat mapping : WHILE "#I" <= CARDINALITY(s_events.event[]) DO
s_events.event["#I"].text1
Relating the above auto generated esql to my original source tree, there cannot be more than more than 2 'LLGEvent' fields as the CARDINALITY(s_events.event[]) is 2. But the broker is erroneously generating 4 'LLGEvent' nodes in the target tree.
Can any one try this & confirm that this is a bug in the product. |
|
Back to top |
|
 |
drivett |
Posted: Tue Dec 21, 2004 9:11 am Post subject: |
|
|
Newbie
Joined: 03 Apr 2002 Posts: 7 Location: Gimlet e-solutions
|
we're having a similar problem with a TDS - TDS mapping going from CSV to fixed format. Basically we can't get the mapping to work. We've spoke to an IBM'er who reckons it may well be a bug, eSQL is out as our client was sold this as having GUI tools without code requirements! So we're in a bit of a fix!!! |
|
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
|
|
|
|