| Author |
Message
|
| kumarjk |
 Posted: Mon May 17, 2010 10:50 am Post subject: How to insert multiple records into a single File? |
 |
|
Newbie
Joined: 17 May 2010
Posts: 2
|
Hello,
I am trying to accumulate multiple records in my message flow and want to send it to a single File using File Output node.
Can you guide me like how the whole process will look loke???
Thanks in advance!!!
Kumar |
|
| Back to top |
|
 |
| eai_guy |
| Posted: Mon May 17, 2010 10:52 am Post subject: |
|
|
Voyager
Joined: 18 Oct 2007
Posts: 90
|
| Are you trying to read these messages from queue , Database . Provide more info please... |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon May 17, 2010 10:53 am Post subject: Re: How to insert multiple records into a single File? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kumarjk wrote: |
| Can you guide me like how the whole process will look loke??? |
It's going to look like a message flow with some kind of input at the front, probably a compute node in the middle and a file output node at the end. Though I imagine you knew that.
Do you have a specific question? How did your prototype go? Did it throw errors? Or fail to assemble the records correctly?
More information, better advice. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kumarjk |
| Posted: Mon May 17, 2010 10:58 am Post subject: |
|
|
Newbie
Joined: 17 May 2010
Posts: 2
|
I am reading messages from SOAP input node and doing the mapping from source to destination and sending it to a file. I am able to send one record to a file.
But the design says to accumulate all records for one day and send all the records to a single file.
So I am not able to figure out to do this task???
Thanks,
Kumar |
|
| Back to top |
|
|
| eai_guy |
| Posted: Mon May 17, 2010 11:00 am Post subject: |
|
|
Voyager
Joined: 18 Oct 2007
Posts: 90
|
| You can always dump those messages in a queue or DB and use timer nodes to get everything in a file. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon May 17, 2010 11:10 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| eai_guy wrote: |
| You can always dump those messages in a queue or DB and use timer nodes to get everything in a file. |
Or read about the "Finish file" terminal of the FileOutput node.
Whichever seems easier, really. |
|
| Back to top |
|
|
| sushilinhere |
| Posted: Wed May 19, 2010 1:27 am Post subject: |
|
|
Newbie
Joined: 17 Apr 2010
Posts: 2
|
Just adding on what has been already said. Incase u havent checked the manual , heres a lil pointer to help . Look into the options of the FileOutput Node and you will see that u can either write all the content in one shot and close the file or u can gradually append data into the same file before closing /finishing it off with some condition. Use a timer to send the final finish to file request at the end of the day and till that point, the appended file will sit in mqsitransit folder.
There are couple of issues using this ( when u have an entire days data to be filled in one file).. incase ur msgflow goes out or broker goes down , then its a lil pain to finish tat file .. ( unless done manually  )
_________________
------------------------------------------------
IBM MBv6.0 Solution Designer
IBM MQ v6.0 System Admin
------------------------------------------------
I dont fight to Win.. I fight Just Coz i HAVE TO!!! ( Same goes for sloth'ing around ) |
|
| Back to top |
|
|
| jbanoop |
| Posted: Wed May 19, 2010 5:01 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
Are you creating the file name dynamically or seting it on the FON ?
For adding records to a file, you might want to look at the 'Record is Delimited Data' option on the FON |
|
| Back to top |
|
|
|
|
