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

Problem

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.

Cause

The batch is dropped due to Netezza semantics.

Solution

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.