on 06-28-2009 7:20 PM
Hi All,
I am working on a File Sender content conversion--> flat file to XI.
it's fixed length field all the rows with same column.
090627 344535AFDFG+GBP65433 ASDSSD GFD dFSSGFD 6757532
090627 344535AFDFG-GBP65433 ASDSSD GFD dFSSGFD 6757532
090627 344535AFDFG-GBP65433 ASDSSD GFD dFSSGFD 6757532
090627 344535AFDFG-GBP65433 ASDSSD GFD dFSSGFD 6757532
090628 344536AFDFG+GBP45434 ASDSSD GFD dFSSGFD 6757532
090628 344536AFDFG-GBP45434 ASDSSD GFD dFSSGFD 6757532
**EOF**
I am sucessfully able to handle the file if i remove "**EOF*" from incoming file. But i get "lastfieldsOptional" error with "*EOF**"
There are parameters available to ignore Last field(last column) of a Row/Rocerdset
but how to ignore the last row of the file.
Plz suggest some parameter to ignore the last row/field of the file.
Regs,
Ansh
Hi Leela,
by giving the mentioned parameters....system asks to define keyfield also..!
whereas i don't hav any field with constant value which can be defined as keyfield.
Regs,
Ansh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ansh,
I have also faced the same problem. For that use the below parameters.
fieldFixedLengths -- 0,0
fixedLengthTooShortHandling -- Cut
Regards,
Leela
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for ur inputs,
i thought about reading "**EOF**" and ignoring it in mapping....but is there no parameter to ignore it while reading itself?
Regards,
Ansh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey
Simplest solution would be to read the last records but ignore itt in Message mapping.don't do any message from that field,it wont be passed to receiver side.
Thanks
Aamir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.