| Author |
Message
|
| francoisvdm |
 Posted: Tue May 02, 2006 12:37 am Post subject: Mapping node data target problem |
 |
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
MB V6
When I create a new mapping node and then I open the map for the first time I do not get the option to select a database as target. I must first go in, select something in a message set as target. Then I must delete this target in the map and then when I add "Sources and Targets" I've got the option to add a table. Do I do something wrong during the initial creation?
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
 |
| narendrach |
| Posted: Tue May 02, 2006 6:47 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
on the target side right click u will see a option called add datasource
u click it u can see a datasource we select it u can add the table to ur target side
_________________
Narendra CH |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Tue May 02, 2006 7:11 am Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
I'm afraid on the screen "Source and Target Mappables" you do not have the option to right click in the window. Remember, then window I'm talking about is the one that appear when you open the map for the first time. It only shows the message sets on the right hand side. It will show the DB on the left hand side but only if you select database as part of the "input" on the previous screen. I do not have the option to pick a different output on that screen.
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
| narendrach |
| Posted: Tue May 02, 2006 9:23 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
Which Mapping node are u using
Mapping Node or DataInsert Node
i think Mapping node does not support the DataBase as target
u need to go for DataInsert Node
_________________
Narendra CH |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Wed May 03, 2006 12:38 am Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
MB V6 mapping node does support DB actions
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Wed May 03, 2006 2:07 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
| Francoisvdm wrote: |
| MB V6 mapping node does support DB actions |
But a Datasource in a mapping node is only on the input side. To use a datasource on the output side, you have to use one of the Dataxxx nodes that also do mapping.
_________________
Bill Matthews |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Thu May 04, 2006 1:53 am Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
no, in V6 the mapping node can map directly into a database.
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Thu May 04, 2006 6:58 am Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
| Francoisvdm wrote: |
| no, in V6 the mapping node can map directly into a database. |
I went and tried what you have described and I belive that I see the confusion. When you add a Mapping node and open the map - the code assumes that you want to map a message, which does include "Select" access to a RDB on the input side - but only a message on the output side.
This is how the mapping node is intended to work.
Once the mapping editor is opened and you delete the output target, you are allowed to once again select the target. This time you can choose between a "Create a Message" or "Modify a Database". This is an either/or choice - not both. Thats why its a radio option and not a check box.
Once you choose one of the database options, you appear to have made the mapping node into a DataBase node - which does not allow for a output message to be created. Whether or not this change actually could produce functional code is unknown. Personally I would not design a product flow that is dependent on this.
Note that this behavior has been in the product since V2 was released. Over time the Compute node was given much more capability in its dealing with databases.
You have also made it difficult for someone else to understand just what your flow is doing based on its appearance.
Now, one might consider this to be a bug - and the bug is that the interface allowed to to select "Modify a Database" after the fact. But, that decision is up to the development team.
_________________
Bill Matthews |
|
| Back to top |
|
|
|
|
