HAVE THE FOLLOWING DATASTAGE ERROR
Mismatch in number of column between data and link
I use datastage 7.5 and use the ABAP pack to extract data. I get the above error after 3.7 million records.
The ABAP stage uses the Build option to generate the ABAP and has two tables joined as an inner join.
Has anyone come across a similiar error. I tried to regenarte the ABAP and update the column list...Everything looks fine and the job aborts after 3.7 million records....
Mismatch in number of column between data and link
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The obvious suggestion is an aberrant row (number 3700001?) with the wrong number of columns - perhaps because of a delimiter character appearing within the data.
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.