Problems with Load - SQLCODE 3107

DB_N00b · #1 (**permalink**) 07-28-11, 03:06

Hello guys,

Today I made an export of a Schema, which was a set of 60 Tables.
Now i import them into my database and half of them get rejected with that error:

* LOAD: table "Schema"."Customers"
*** WARNING 3107. Check message file tab7.msg!
*** SQL Warning! SQLCODE is 3107
*** SQL3107W There is at least one warning message in the message file.

DB_N00b · #2 (**permalink**) 07-28-11, 03:08

Now when i check tab7.msg there are tons of errors like:

Quote:

SQL3550W The field value in row "F0-7839" and column "1" is not NULL, but the
target column has been defined as GENERATED ALWAYS.

SQL3185W The previous error occurred while processing data from row "F0-7839"
of the input file.

SQL3550W The field value in row "F0-7840" and column "1" is not NULL, but the
target column has been defined as GENERATED ALWAYS.

DB_N00b · #3 (**permalink**) 07-28-11, 03:08

What can I do here in best case? Thank you for your help in advance!

przytula_guy · #4 (**permalink**) 07-28-11, 03:31

have a look at messages and code
SQL3550W
..the generatedoverride file type modifier can be used to load explicit, non NULL values into a row..
to avoid a next question : the load syntax is :
LOAD

DB_N00b · #5 (**permalink**) 07-28-11, 04:43

Thank you!

Internet Services

Web Development

Digital Marketing

Consumer Tech