"Too many columns in record" - How to resolve this
Moderators: chulett, rschirm, roy
"Too many columns in record" - How to resolve this
hi guys:
I have the fiollwoing error when I try to read a file in datastage.
read_delimited() - row 1, too many columns in record
I checked the file layout on the Unix box and it exactly matches the column layout of the Datastage job.
Please advise if this could be for a diff reason.
I have the fiollwoing error when I try to read a file in datastage.
read_delimited() - row 1, too many columns in record
I checked the file layout on the Unix box and it exactly matches the column layout of the Datastage job.
Please advise if this could be for a diff reason.
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
Could you provide some sample lines from the file in question?
I'd include row 1 too (As it is the one mentioned in the error message).
I'd include row 1 too (As it is the one mentioned in the error message).
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
This might be the likely solution
Check for Line Termination option in ur sequential stage whether it is Unix style or DOS style.
Regards,
Suresh N
Regards,
Suresh N
SURESH NARASIMHA
Re: This might be the likely solution
Thanks Narasimha, somehow it was defaulted to DOS style, I changed it to Unix style and it worked.
Re: "Too many columns in record" - How to resolve
Also there is another reason this error could pop up. This happened to me.
When you have a field name in the source file that you forgot to include in the output columns list then the exact same error pops up.
When you have a field name in the source file that you forgot to include in the output columns list then the exact same error pops up.