JR34039: DATA TRUNCATED AT NULL BOUNDARIES FOR NVARCHAR COLUMNS

APAR status

• Closed as program error.

Error description

• The job uses Oracle Connector stage with NVarChar column on the
  output link to read data from a text column in Oracle table.
  Some of the column values contain NULL characters. The
  connector truncates these values at the first NULL character.
  It treats the NULL character as the value terminator. Instead
  the connector should read the value in its entirety,
  including any NULL characters in the value.
  

Local fix

• Use VarChar column instead of NVarChar column on the output
  link, and do not set the Extended column attribute to Unicode.
  The character set encoding of the value will be determined by
  the NLS_LANG setting.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  The users of Oracle Connector who extract text data will NULL
  values using DataStage NVarChar columns on the output link.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When extracting values from character columns in the Oracle
  table (for example VARCHAR2, NVARCHAR2, etc) and the
   corresponding columns on the output link were of NVarChar type
  or VarChar type with Extended attribute set to Unicode, the
  connector would not preserve NULL characters in the text values
  but would treat the NULL characters as value terminators and
  would therefore truncate the value at those NULL character
  boundaries.
  ****************************************************************
  RECOMMENDATION:
  Install Connector Rollup Patch 2 (CCRP2).
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• The code was fixed to preserve NULL characters in the extracted
  column values.
  

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

• R810 PSN

     UP