LOAD message file

[efiryago@profitlogic.com]

From the message file generated by LOAD utility:

SQL3119W The field value in row "F1-14" and column "14" cannot be converted
to an INTEGER value. A null was loaded.

how do I identify the line in the load file that caused the exception above?

Thanks
-Eugene

[miro flasza]

[email]efiryago@profitlogic.com[/email] wrote:

> From the message file generated by LOAD utility:
>
> SQL3119W The field value in row "F1-14" and column "14" cannot be converted
> to an INTEGER value. A null was loaded.
>
> how do I identify the line in the load file that caused the exception above?
>
> Thanks
> -Eugene

Look further down in the message file, there should be another message
saying what line number in the input file does F1-14 map to.

Regards,
Miro

[efiryago@profitlogic.com]

miro flasza <miro@torolab.ibm.com> wrote in message news:<bjed48$749$1@hanover.torolab.ibm.com>...

> [email]efiryago@profitlogic.com[/email] wrote:

> > From the message file generated by LOAD utility:
> >
> > SQL3119W The field value in row "F1-14" and column "14" cannot be converted
> > to an INTEGER value. A null was loaded.
> >
> > how do I identify the line in the load file that caused the exception above?
> >
> > Thanks
> > -Eugene

>
> Look further down in the message file, there should be another message
> saying what line number in the input file does F1-14 map to.
>
> Regards,
> Miro

Thank you Miro, I got it.