| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| File Extender EOF |
« View previous topic :: View next topic » |
| Author |
Message
|
| Bravo |
 Posted: Wed Oct 25, 2006 10:29 am Post subject: File Extender EOF |
 |
|
Centurion
Joined: 03 Oct 2005
Posts: 146
|
Hi All,
I'm using MB ver 5 with File extender.
I am getting a fixed format file from iSeries(AS/400) thru an FTP.Each record length is 500 and represent separate row.The file has some special character(little square on the last row) after the last record in a separate row.
When I tried to read a file, record by record the special character is treated as a separate record even after setting the FileInputNode format properties EOR as Native(the platform EOR).
I asked the sender to strip the specail charater before doing FTP. But his response was "(the little square on the last row) is an end of file marker. It gets generated by the iSeries CPYTOIMPF (copy to import file) " command.
Is there anyway to strip the special character during FTP or how can I treat the special character as EOF using FileInputNode?
Any suggestion!!
_________________
Bravo |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Wed Oct 25, 2006 7:18 pm Post subject: Re: File Extender EOF |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Bravo,
| Bravo wrote: |
| Each record length is 500 and represent separate row.The file has some special character(little square on the last row) after the last record in a separate row. |
The little square(or rectangle actually) must be the new line indicator...If you put all your records in a line that "special character" should vanish...but I guess that's not what u want.
| Bravo wrote: |
| When I tried to read a file, record by record the special character is treated as a separate record even after setting the FileInputNode format properties EOR as Native(the platform EOR). |
You mean you receive a blank record ? That sounds weird...can u paste a sample of your input file.
Regards. |
|
| Back to top |
|
|
| Bravo |
| Posted: Mon Nov 06, 2006 10:25 am Post subject: |
|
|
Centurion
Joined: 03 Oct 2005
Posts: 146
|
Sorry for the late response.
I raised this issue to AS/400 programmer..he is looking into this.
I have another situation:
The AS/400 programmer sends the file which is fixed length record 500 thru CPYTOIMPF command(IBM utility to import file) with the EOR(End of record) delimiter.
But when I look at the flat file, the EOR delimiter is coming in different position in each record, So I cannot use the CWF as message set for mapping. Here is the input msg
For eg :
| Code: |
X 12345 X 1234 TYTUY 17817(EOR)
Y 6798 2 1223 T(EOR)
T TTYT 3 4567 UYUYI 123(EOR)
|
The last two fields of the record are occurance.
Each record is input message and I want to convert into XML.
Any suggestion.
_________________
Bravo |
|
| Back to top |
|
|
| dave moule |
| Posted: Wed Nov 15, 2006 4:56 am Post subject: |
|
|
Novice
Joined: 01 Oct 2002
Posts: 12
Location: Hursley, United Kingdom
|
>>>When I tried to read a file, record by record the special character is treated as a separate record even after setting the FileInputNode format properties EOR as Native(the platform EOR).
If you have a special set of characters marking your end of record you can specify them expllicitly using the new FP3 feaure.
See section "Working with custom end of record characters" in the 3rd edition of the user guide that comes with FP3.
Regards,
Dave Moule,
IBM Hursley |
|
| 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
|
|
|
|
