Page 1 of 1
Read_fixedwidth()
Posted: Tue May 03, 2005 8:13 am
by kollurianu
Hi All,
Could some one please tell me what does this error indicate
Code: Select all
.duns_ipfile.Input: read_fixedwidth() - row 1, too many columns in record
Thank you all,
Posted: Tue May 03, 2005 8:41 am
by ds_developer
Without further details, I'd say:
1. you are reading in a fixed width sequential file.
2. you have fields defined that say add up to 100 bytes
3. the first record is being read in and there are more than 100 bytes before the line terminator
You have extra data in the record, so it tells you there are 'too many columns'.
John
Posted: Tue May 03, 2005 12:29 pm
by kommven
Anu,
Solution underlies with the fact how the line terminates...
The available 2 options you can specify are
CR/LF
binary
will be ASCII or EBCIDIC
knowing and specifying them will help or try combinations trail and error...
in your scenario I strongly believe that its binary deliminated...
Good luck,
Posted: Wed May 04, 2005 4:26 am
by Sainath.Srinivasan
Can you view the file in Unix to confirm the length and layout? Did you obtain the file from other OS such as DOS or Win?