Mismatch in number of column between data and link

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
koojo
Premium Member
Premium Member
Posts: 43
Joined: Sun Jul 11, 2004 1:30 pm
Location: USA

Mismatch in number of column between data and link

Post by koojo »

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.... :cry:
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply