Error while loading DB2 UDb Bulk Loader SQLCODE : 3107W

[adithfrancis]

Hi,

I am trying to load Data using the DB2 UDB Bulk loader stage, but data is not loaded into the Table . a warning message is shown.

Error message :
ERROR occurred : loading table, SQLCODE 3107
SQL3107W There is at least one warning message in the message file.

In the local message file it is shown as :
SQL3227W Record token "F1-18" refers to user record number "98".
SQL3227W Record token "F1-19" refers to user record number "99".
SQL3227W Record token "F1-20" refers to user record number "100".
SQL3110N The utility has completed processing. "100" rows were read from the input file.
SQL3519W Begin Load Consistency Point. Input record count = "100".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "12/21/2007
15:32:37.141700".
SQL3107W There is at least one warning message in the message file.

I am not able to figure out where the error is occuring .
Could someone guide me on this issue .

Regards

Adith

[adithfrancis]

Hi ,
In Addition to this i have a column in the table as HIID (Integer )which is not nullable , while populating the table i have not taken this particular column HIID since this column will be automatically incremented for every record writing into the table.

I checked the Local message file . in it was mentioned that the records were rejected
Eg :
SQL3120W The field value in row "F0-1" and column "1" cannot be converted to
an INTEGER value, but the target column is not nullable. The row was not
loaded.

Is there some place In the properties where i can mention about HIID and it increments automatically.

Regards

Adith