ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem Mapping repeating structure

Post new topic  Reply to topic
 Problem Mapping repeating structure « View previous topic :: View next topic » 
Author Message
sieijish
PostPosted: Thu Dec 16, 2004 2:41 pm    Post subject: Problem Mapping repeating structure Reply with quote

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
View user's profile Send private message
sieijish
PostPosted: Fri Dec 17, 2004 2:22 am    Post subject: Reply with quote

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
View user's profile Send private message
Ramphart
PostPosted: Fri Dec 17, 2004 4:21 am    Post subject: Reply with quote

Disciple

Joined: 21 Jul 2004
Posts: 150
Location: South Africa, JHB

Hi,

Look at this link. Maybe it is useful.

http://www.mqseries.net/phpBB2/viewtopic.php?t=19306&highlight=
_________________
Applications Architect
Back to top
View user's profile Send private message
sieijish
PostPosted: Mon Dec 20, 2004 2:44 am    Post subject: Is this a bug in WBIMB version 5 Reply with quote

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
View user's profile Send private message
drivett
PostPosted: Tue Dec 21, 2004 9:11 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem Mapping repeating structure
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.