Search code examples
db2db2-luw

How to find row in DB2 .DEL file by identifier from LOAD log file

I'm trying to load data into DB2 for LUW table from .DEL file previously exported with EXPORT command:

LOAD CLIENT FROM f:\file.del OF DEL messages f:\file.log insert INTO sch.tab

Got some rows rejected. Trying to find problem data by log file but do not understand how to find exact row having messages like this:

SQL3120W The field value in row "F29-841936" and column "1" cannot be converted to an INTEGER value, but the target column is not nullable. The row was not loaded.

Solution

  • The problem was with EOL (ASCII code 10 or 13) symbols occured inside of VARCHAR or CHAR fields. The solution was to use DELPRIORITYCHAR modifier.