Netezza Exports Fail with a Column Value of "Null'"


Netezza exports fail if a column in that export has a value of "null'" and the batch size is more than 1. In this scenario, the completed batch is dropped.


The batch is dropped due to Netezza semantics.


To solve this problem, you can either:

  • Perform data preparation in the workbook and transform the null' value into a different value. The value is transformed before exporting into Netezza.
  • Use a batch size of 1, however this might cause slow performance for export jobs.