Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    23

    Unanswered: Details of Rejected rows from DB2 Import

    I'm using DB2 v 9.1 LUW. I'm importing a pipe-delimited text file and want to know if there is a way of outputting the rejected records into a text file?

    SQL3149N "30467" rows were processed from the input file. "0" rows were
    successfully inserted into the table. "30467" rows were rejected.

    If so, could please give me an example or details on how to do this?

    Thank you.


    CC

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The import message file (the one you specify with the MESSAGES clause) list every problem line. The LOAD command can move failing lines into the exception table.

Posting Permissions

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