Topic
2 replies Latest Post - ‏2012-08-05T15:19:40Z by BharathSubash
BharathSubash
BharathSubash
3 Posts
ACCEPTED ANSWER

Pinned topic DB2: Fail LOAD command on rejectnig records

‏2012-07-26T10:59:37Z |
Hi,

I'm using LOAD CLIENT utility in DB2 for loading data from file to my table. Records are getting rejected since it has null value for a not null column.

Is there any way where i can make the LOAD fail if any record is rejected?

Regards,
Bharath
Updated on 2012-08-05T15:19:40Z at 2012-08-05T15:19:40Z by BharathSubash
  • nivanov1
    nivanov1
    22 Posts
    ACCEPTED ANSWER

    Re: DB2: Fail LOAD command on rejectnig records

    ‏2012-08-02T14:24:59Z  in response to BharathSubash
    Specify WARNINGCOUNT 1 in the LOAD command (you'll need to edit db2load.sql).
    • BharathSubash
      BharathSubash
      3 Posts
      ACCEPTED ANSWER

      Re: DB2: Fail LOAD command on rejectnig records

      ‏2012-08-05T15:19:40Z  in response to nivanov1
      Thanks buddy.. Correct me if i'm wrong, If we give Warningcount 1, load will fail on any warnings, but we have to fail the load only when the record is rejected.