Topic
2 replies Latest Post - ‏2012-04-24T13:56:22Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts
ACCEPTED ANSWER

Pinned topic Data that has carriage return fails to load in Netezza

‏2012-04-18T14:26:04Z |
Hi,
I am moving tables from Oracle to Netezza. My Oracle data has carriage return in some varchar columns. When I try to load it in Netezza, it fails. As soon as it gets to carriage return, it thinks it is the end of the record:

Found bad records

bad #: input row #(byte offset to last char examined) field #, declaration diagnostic, "text consumed"last char examined

1: 18(6) 2, VARCHAR(50) missing field - fillRecord not enabled, "MA"0x0a<LF>

How do I fix this?
Thanks,
Marjana
Updated on 2012-04-24T13:56:22Z at 2012-04-24T13:56:22Z by SystemAdmin
  • ChuanKaiChen
    ChuanKaiChen
    10 Posts
    ACCEPTED ANSWER

    Re: Data that has carriage return fails to load in Netezza

    ‏2012-04-24T08:04:34Z  in response to SystemAdmin
    In your case, you need to add a DELPRIORITYCHAR parameter to the load command, like this:
    db2 LOAD FROM file.del OF DEL MODIFIED BY DELPRIORITYCHAR INSERT INTO db2inst1.employee

    Maybe you need to edit the db2load.sql by yourself after the IDMT extracted.
    • SystemAdmin
      SystemAdmin
      708 Posts
      ACCEPTED ANSWER

      Re: Data that has carriage return fails to load in Netezza

      ‏2012-04-24T13:56:22Z  in response to ChuanKaiChen
      I am loading into Netezza, not DB2. I think I should post my question on Netezza forum rather than here.