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

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

    Re: DB2: Fail LOAD command on rejectnig records

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

    Re: DB2: Fail LOAD command on rejectnig records

    ‏2012-08-05T15:19:40Z  
    • nivanov1
    • ‏2012-08-02T14:24:59Z
    Specify WARNINGCOUNT 1 in the LOAD command (you'll need to edit db2load.sql).
    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.