APAR status
Closed as program error.
Error description
From source file, we are generating Dataset and from Dataset to target table. Some of the records getting dropped while reading from Dataset. Appears Dataset is generating control/unknown character into dataset and not able to load into target (oracle) table.
Local fix
This fix is included in 8.0.1 fixpack 3
Problem summary
**************************************************************** USERS AFFECTED: All. **************************************************************** PROBLEM DESCRIPTION: Some numeric fields are loaded erroneously as NULL. Numeric fields whose precision is an odd number load as NULL when the value happens to leading two digits as 20. Work around is to increase the precision of the effected field if you know which. Applying this patch is highly recommended. **************************************************************** RECOMMENDATION: apply provided patch. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
There is a problem with the NULLIF clause encoding for decimal loader type fields in the loader control file. The problematic NULLIF clause encoding stands now corrected.
Temporary fix
Comments
APAR Information
APAR number
JR34496
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
802
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-10-08
Closed date
2009-10-15
Last modified date
2010-12-09
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
R802 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":"802","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010