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?
This topic has been locked.
2 replies Latest Post - 2012-04-24T13:56:22Z by SystemAdmin
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 PostsACCEPTED ANSWER
Re: Data that has carriage return fails to load in Netezza2012-04-24T08:04:34Z in response to SystemAdminIn 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.