Posted: Fri Aug 19, 2011 10:11 pm Post subject: FIle Input node in MB7.0.0.1
Newbie
Joined: 20 Jul 2010 Posts: 5
Hi,
We have a requirement where we need to read a huge file(10 MB) using FileInput Node record by record and batch 100 records each and create the XML out of it and send it and take the next set of records and proceed the similar way. Every time we pick the record and save in Env Tree, when the next record is picked as its a new txn, the env tree is getting cleared. Any help on how to save the Env tree or process this request would be great.
Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land.
there are several ways to solve your problem
You could read the whole file in one go and then loop through the records building your output message as you go.
you could read each record and write it to a DB table. When you have enough you can select all the rows, build your message and send it then truncate the table
You could store the records in a Shared ESQL Row and etc etc
Each of these will have their own +ve's and -ve's. It is up to you to decide which is the best way for your site. _________________ WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
You could rework your model such that it thought that a single "record" consisted of up to 100 of the things it currently thinks are "records" and then tell the FileInput node to read the file by records.
You could figure out the fixed length that corresponded to 100 records.
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