| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Insert repeat XML field into Multiple rows |
« View previous topic :: View next topic » |
| Author |
Message
|
| Bell Hung |
 Posted: Sun May 12, 2002 7:58 pm Post subject: Insert repeat XML field into Multiple rows |
 |
|
Newbie
Joined: 05 Dec 2001
Posts: 5
Location: Taiwan
|
Hello all :
How can I insert repeating XML fields into multiple rows in DataInsert node. I've saw that DataInsert node can insert one or multiple rows into DB. But when I mapping XML field into ODBC row , only one record inserted into DB.
For example , I have one message InputRoot.XML.F1[1],F1[2]
and want to inser into table Field with two different rows.
Should I use DataInsert node or Database node to handle this request ? |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon May 13, 2002 4:33 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Bell,
If you want to use DataInsert node, you will have to use some kind of "loop" (if not using WMQI 2.1), a combination of Filter node, 2 Compute Nodes and single DataInsert node. I wouldn’t recommend this.
With WMQI 2.1, you can make use of propagate command to send repeating xml elements as single XML message to datainsert node.
Finally, you can use Database node instead, with a FOR/WHILE loop to traverse XML tree and then insert repeating XML elements into database. This will work with MQSI2.0.x/WMQI2.1.
Hope this helps.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
