| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Mapping a target element from database tables Issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| goldym |
 Posted: Thu Jun 08, 2006 6:38 pm Post subject: Mapping a target element from database tables Issue |
 |
|
Centurion
Joined: 24 Jun 2005
Posts: 116
|
Can anyone help>
I am trying to Extract Data from a Database and into a XML using the mapping node.
The help is confusing. Does anyone know what I need to do to get started. Draggin gand dropping is the last step and not the first. I have a Database with just one row and trying to map those 5 fields in to the XML. I dont know how to setup the first
per the help:
To map a target element from a database table, set up the Mapping node to:
retrieve the relevant rows from the database
populate the message target elements with values from database After you have added a database to the mapping, the Spreadsheet pane contains a $db:select entry in the Map Script column. By default, its value is fn:true(), which means that all rows are retrieved from the database table.
Do I just leave it fn:true(), and drag my fields in the edit pane? |
|
| Back to top |
|
 |
| goldym |
| Posted: Fri Jun 09, 2006 4:44 pm Post subject: Mapping a target element fr database tables Issue- Resloved |
|
|
Centurion
Joined: 24 Jun 2005
Posts: 116
|
[quote="goldym"]Can anyone help>
I am trying to Extract Data from a Database and into a XML using the mapping node.
The help is confusing. Does anyone know what I need to do to get started. Draggin gand dropping is the last step and not the first. I have a Database with just one row and trying to map those 5 fields in to the XML. I dont know how to setup the first
per the help:
To map a target element from a database table, set up the Mapping node to:
retrieve the relevant rows from the database
populate the message target elements with values from database After you have added a database to the mapping, the Spreadsheet pane contains a $db:select entry in the Map Script column. By default, its value is fn:true(), which means that all rows are retrieved from the database table.
Do I just leave it fn:true(), and drag my fields in the edit pane?[/quote]
Issue Resolved - had to move the "$target" under the "for". |
|
| 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
|
|
|
|
