Read_fixedwidth()

[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,

[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

[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,

[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?