LOAD message file
This is a discussion on LOAD message file within the DB2 forums, part of the Database Server Software category; --> From the message file generated by LOAD utility: SQL3119W The field value in row "F1-14" and column "14" cannot ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 02:43 PM
| ||||
| ||||
 LOAD message file 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      |
|
02-26-2008, 02:43 PM
| |||
| |||
| Re: LOAD message file efiryago@profitlogic.com 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 |
|
02-26-2008, 02:43 PM
| ||||
| ||||
| Re: LOAD message file miro flasza <miro@torolab.ibm.com> wrote in message news:<bjed48$749$1@hanover.torolab.ibm.com>... > efiryago@profitlogic.com 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. |
Linear Mode
