EOR character in fixed width file on UNIX

[ketfos]

Hi,
I am reading from Unix Sequential file - fixed width format and
writing to Oracle table.
I am getting an error while I am writing to the table.

LoadStage.MPNO.InRecord: read_fixedwidth() - row 53161308, column TXT, column unexpectedly ended by EOR

The total number of records in the input file are 63161900.

How do I find the error record?

Thanks
Ketfos

[kris007]

Go to the columns tab in the sequential file and try setting the attribute Contains Terminators to Yes for column TXT and see if the error still pops up.

HTH

[kcbland]

Code: Select all

head -n53151310 yourfile|tail -4

Should be sufficient to scan thru all lines up until 2+ where the issue is reported, then display the last 4 lines. Go get a cup of tea and a biscuit while it runs.