| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DBInsert Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| hascheidl |
 Posted: Fri Jun 16, 2006 5:17 am Post subject: DBInsert Node |
 |
|
Novice
Joined: 05 Jun 2006
Posts: 15
|
Hi,
I'm trying to use DBInsert node. I've created the mapping for the input message, and I've imported the dbschema. Also, I've made the mapping, linking corresponding fields. The problems is: the node inserts a row for each field in the mapping. So, for a message with three fields, I'd have the following pattern in the table:
Field1 Field2 Field3
nono [null] [null]
[null] nono [null]
[null] [null] nono
Obviously, what I want is a unique record inserted. How do I achieve this? Thanks in advance.
_________________
Half |
|
| Back to top |
|
 |
| mqmaniac |
| Posted: Fri Jun 16, 2006 5:52 am Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
| Can you Give some more Info abt tyhe schema and the Mapping..I had an Issue like this and It was the Mapping which was done wrong.. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Jun 16, 2006 6:35 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi hascheidl,
Are you on v5...if you are then you got to select all the elements that you want inserted together and right-click to find a particular option which inserts as one row....
If you are on v6, then there should be something similar, have not tried it myself  but i do remember someone on this forum asking the very same doubt for v6....Please try a search...
And if you find it plz post the link here too 
Regards. |
|
| Back to top |
|
|
| hascheidl |
| Posted: Fri Jun 16, 2006 7:42 am Post subject: |
|
|
Novice
Joined: 05 Jun 2006
Posts: 15
|
Thank you!
I had to search a bit... The option "Combine to same row" is available in the Outline view. Thanks again.
_________________
Half |
|
| 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
|
|
|
|
