Hi All,
I am reading a fixed width column file and loading into oracle table and in the same job in , before job subroutine i am calling unix script through which i am adding two constant value eg. STORE_ID & FILE_Date in the starting of each record.
But when i trigger the job it is finishing with see log having following error
" read_fixedwidth() - row 32, too many columns in record ".
This error is on last line of the file means 32 is the last line of file.
Pls suggest any solution for the same.
Fixed width file job finished with see log
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
Fixed width file job finished with see log
Thanks,
Sourabh Verma
Sourabh Verma
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Well, if there's a line terminator, then there are too many characters in that line - your fixed width table definition specifies the width.
When you're viewing the file using a UNIX utility, is line #32 longer than line #31? Does line #32 contain any other non-printing characters, such as a tab (^I)?
When you're viewing the file using a UNIX utility, is line #32 longer than line #31? Does line #32 contain any other non-printing characters, such as a tab (^I)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 74
- Joined: Thu Jan 05, 2006 2:07 am