Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    12

    Unanswered: One question on DB2 LOAD

    Hello Everyone,
    I have a small query on DB2 LOAD. Sometimes there are errors/warnings in the message file like the one below:-

    SQL0180N The syntax of the string representation of a datetime value is
    incorrect. SQLSTATE=22007

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

    Is there any was of getting the corresponding column name in the message file?

    Regards
    Ashwin

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have a look at the FOR EXCEPTION clause of the LOAD command. That allows you to specify a table where erroneous rows will be copied to. So you can do the load and analyze the problematic rows (and only those) afterwards.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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