JR41980: NETEZZA COMMON CONNECTOR INCORRECTLY RETURNS N INSTEAD OF NULL

IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• When reading a large number of rows via the Netezza CC, it is
  possible that a tiny number of columns could incorrectly return
  the value 'N' instead of NULL when the column contains a NULL
  value.
  
  During testing, out of 2 million rows of which 200,000 contained
  columns set to NULL, 13 of these returned 'N' instead of NULL.
  

Local fix

Problem summary

• When reading a large number of rows via the Netezza CC, it is
  possible that a tiny number of columns could incorrectly return
  the value 'N' instead of NULL when the column contains a NULL
  value.
  

Problem conclusion

• Install the patch
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R850 PSY

     UP

• R870 PSY

     UP