| Author |
Message
|
| chanduy9 |
 Posted: Mon Feb 18, 2002 8:46 am Post subject: |
 |
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
HI,
can anybody suggest how to convert multiple records( number of records vary)f1lat file from MRM to XML.
Thanks in advance.
Chandra. |
|
| Back to top |
|
 |
| Segs |
| Posted: Tue Feb 19, 2002 8:21 am Post subject: |
|
|
Voyager
Joined: 04 Oct 2001
Posts: 78
Location: Zurich Financial Services
|
Without knowing more detail about the file coming in, it's difficult to help, but you may be able to create an occurs depending structure within a COBOL copybook and import this to the MRM. I posted an example about this earlier this year, you should be able to find the link by searching for occurs or invoice. If this doesn't help please reply.
Thanks
Ken... |
|
| Back to top |
|
|
| chanduy9 |
| Posted: Tue Feb 19, 2002 9:00 am Post subject: |
|
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
Hi,
my incoming file is flatfile with multiple records, i have to find out the number of records in that file, then i have to use occurs depending on...i am able to find the number of records..but when i am reading the input file i am unable to read the number of records which i have calculated, i want to add this number to the incoming file, then i can use that number for occurs depending..but i am unable to read the number to the incoming file.
Thanks,
Chandra. |
|
| Back to top |
|
|
| ksilpaa |
| Posted: Thu Feb 28, 2002 2:10 pm Post subject: |
|
|
Novice
Joined: 17 Dec 2001
Posts: 10
|
This is very easy to do think you would get it.
_________________
Silpa |
|
| Back to top |
|
|
| EddieA |
| Posted: Mon Mar 04, 2002 3:11 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Chandra,
You could use NEON and the NEONMSG domain. That has the ability to parse a message containing an unknown number of repeats.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| Paul D |
| Posted: Thu Mar 14, 2002 1:24 pm Post subject: |
|
|
Master
Joined: 16 May 2001
Posts: 200
Location: Green Bay Packer Country
|
| I did a similar thing using the MQGet node to combine multiple input records into one. I was trying to combine records based in a set of key fields. I'd sort these and then import them into my input queue. My flow used the MQGet node and would put and get messages to a temp queue until I hit the "break", in that case, I'd write out the summarized record into the real output queue. That message in the temp queue had an XML array of the transactions I was accumulating. What you really need is a temp table type area. You could use a database table, a queue, or even memory like the MQPostit node uses. I used a queue. I had a End of file message at the end to mark the end of processing and release the last batch/aggegrated message. |
|
| Back to top |
|
|
|
|
