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?
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Pinned topic Data that has carriage return fails to load in Netezza
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-04-24T13:56:22Z at 2012-04-24T13:56:22Z by SystemAdmin
ChuanKaiChen 270004V9H310 Posts
Re: Data that has carriage return fails to load in Netezza2012-04-24T08:04:34ZThis is the accepted answer. This is the accepted answer.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 110000D4XK708 Posts
Re: Data that has carriage return fails to load in Netezza2012-04-24T13:56:22ZThis is the accepted answer. This is the accepted answer.
- ChuanKaiChen 270004V9H3