| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Flat file Data to be inserted into a Table |
« View previous topic :: View next topic » |
| Author |
Message
|
| mvsivaiah |
 Posted: Wed Sep 10, 2008 6:01 am Post subject: Flat file Data to be inserted into a Table |
 |
|
Apprentice
Joined: 30 May 2008
Posts: 25
|
Hi All, Please  me.
I've data values separated by spaces in a flat (text) file. I would like to enter these values into columns of a Table (database). The data to be appended in the table every time, when the flow runs. Also I need to load the data only when the error code is '0', which is a data value in the same flat (text) file.
I've a doubt with: how to read and load the data (separated by spaces) to particular columns of table, at a particular condition?
Please guide me with possible solutions/designs to achieve this task?
_________________
Venkat. |
|
| Back to top |
|
 |
| kimbert |
| Posted: Wed Sep 10, 2008 6:39 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
Create a message set with a TDS physical format.
Create a message flow, and on the input node specify the MRM parser, and the message set, type and physical format
In a Compute node, query the message tree for the error code. If it is 0, put the values into the database.
If that does not make sense, you should probably start by looking at some of the samples in the Samples gallery. |
|
| 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
|
|
|
|
