Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2010
    Posts
    206

    Unanswered: Problems with Load - SQLCODE 3107

    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.

  2. #2
    Join Date
    Jan 2010
    Posts
    206
    Now when i check tab7.msg there are tons of errors like:

    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.


  3. #3
    Join Date
    Jan 2010
    Posts
    206
    What can I do here in best case? Thank you for your help in advance!

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jan 2010
    Posts
    206
    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •