| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problem inserting record with DataInsert node in WBIMB 5.0 |
« View previous topic :: View next topic » |
| Author |
Message
|
| cadenza |
 Posted: Sun Jun 20, 2004 11:53 pm Post subject: Problem inserting record with DataInsert node in WBIMB 5.0 |
 |
|
Apprentice
Joined: 01 Jun 2004
Posts: 48
|
Hi All,
I am facing a typical problem.
Suppose my input xml is :
<Book>
<Title>The Adventures of Tom Sawyer</Title>
<Author>Mark Twain</Author>
<Publisher>Penguin</Publisher>
</Book>
I have a table Book in DB2 having fields Title, Author and Publisher.
My Message Flow input is XML, which I take it in MQInput. I connect MQInput to DataInsert Node and map the input message to the database fields, using the .mfmap file. I have not used any ESQL for the above. I am connecting the DataInsert node to the Compute node where I am doing some other processing, and the output received is fine.
After I put the message, I find that data is updated in the database, but not in the desired format.
My requirement is:
******************************************************
|Title | Author | Publisher |
******************************************************
The Adventures of Tom Sawyer| Mark Twain| Penguin
*******************************************************
But the Output is:
******************************************************
|Title | Author | Publisher |
******************************************************
| Mark Twain|
---------------------------------------------------------------------------------
The Adventures of Tom Sawyer| |
---------------------------------------------------------------------------------
| | Penguin
*******************************************************
In other words, I would like the data to be inserted as one record only. But I am getting three records.
Thanks. |
|
| Back to top |
|
 |
| leongor |
| Posted: Mon Jun 21, 2004 4:22 am Post subject: |
|
|
Master
Joined: 13 May 2002
Posts: 264
Location: Israel
|
In Outline view you need to select 3 rows you mapped and right click them with "Combine To One Row".
_________________
Regards.
Leonid.
IBM Certified MQSeries Specialist. |
|
| Back to top |
|
|
| kalva7 |
| Posted: Mon Jun 21, 2004 4:28 am Post subject: |
|
|
Novice
Joined: 18 Sep 2003
Posts: 21
Location: Pune,India
|
Hey,
After mapping the data, go to the outline , select all the mappings established, right click and choose combine to same row--->remove slected mappings, then only one record will be inserted wth all fields.
Cheers,
Chandra |
|
| Back to top |
|
|
| cadenza |
| Posted: Mon Jun 21, 2004 4:54 am Post subject: Problem Solved |
|
|
Apprentice
Joined: 01 Jun 2004
Posts: 48
|
Hi leonid and chandra,
Thanks for the prompt response.
I tried that and it is now working fine.
Thanks. |
|
| 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
|
|
|
|
