A fix is available
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 number
JR41980
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
870
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-02-18
Closed date
2012-03-01
Last modified date
2012-03-01
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.7"}]
Document Information
Modified date:
07 October 2021