JR33670: DATASTAGE 7.5.3: ORACLE EE STAGE WITH LOAD METHOD SHOULD NOT APPEND SPACES

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 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