Page 1 of 1

Mismatch in number of column between data and link

Posted: Mon Jun 27, 2005 11:21 am
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:

Posted: Mon Jun 27, 2005 7:06 pm
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.