APAR status
Closed as program error.
Error description
SCD Stage rejects rows with NULL Type 2 fields if one input is of Extended Type Unicode and the other is NOT. Director reports record dropped: APT_CombinedOperatorController(6),0: Field 'Column_A' from input dataset '0' is NULL. Record dropped.
Local fix
Both source columns have to be of same type, either Unicode or non-Unicode
Problem summary
**************************************************************** USERS AFFECTED: Users using SCD stage. **************************************************************** PROBLEM DESCRIPTION: The drop is caused by column type mismatch. **************************************************************** RECOMMENDATION: Install the new patch for this case. This fix is included in 81 FP1 ****************************************************************
Problem conclusion
Added extra code to generate implicit conversion before comparing the type2 columns with different data types.
Temporary fix
Comments
APAR Information
APAR number
JR30746
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-10-09
Closed date
2010-01-21
Last modified date
2010-01-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
1
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
21 January 2010