APAR status
Closed as program error.
Error description
At DataStage 7.5.3 a job with the Oracle EE stage is appending spaces through the end of the field when a varchar or char column is loaded. Eaxmple: Tbl definition col1 varchar(12) col2 varchar(5) col1 = "CO" col2 = " " Loaded: col1 "CO " col2 " " Expected results: col1 "CO" col2 " "
Local fix
This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: all users. **************************************************************** PROBLEM DESCRIPTION: At DataStage 7.5.3 a job with the Oracle EE stage is appending spaces through the end of the field when a varchar or char column is loaded. **************************************************************** RECOMMENDATION: apply patch provided. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
We have set APT_ORACLE_PRESERVE_BLANKS, but looking at previous cases and ecase 111395 the expected behavior is that it will preserver the blanks that exist in the customer data, but it will not append trailing blanks. There is only one condition under which string schema fields need to be loaded using loader type varchar. This condition occurs if (1) APT_ORACLE_PRESERVE_BLANKS is setand (2) table column type VARCHAR2. For all other conditions, we can load using loader type CHAR without any issue. For loading ustring schema types, the situation is different. We need to use loader type varchar whenever the field can packmore utf8 characters than the table column can take or whenever we are preserving blanks with APT_ORACLE_PRESERVE_BLANKS.
Temporary fix
Comments
APAR Information
APAR number
JR33670
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
753
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-07-15
Closed date
2009-08-05
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
R753 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":"7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010