IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 2 replies
  • Latest Post - ‏2012-04-24T13:56:22Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts

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

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

    ‏2012-04-24T08:04:34Z  
    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

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

    ‏2012-04-24T13:56:22Z  
    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.
    I am loading into Netezza, not DB2. I think I should post my question on Netezza forum rather than here.