IBM Support

JR34039: DATA TRUNCATED AT NULL BOUNDARIES FOR NVARCHAR COLUMNS

Subscribe

You can track all active APARs for this component.

 

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 number

    JR34039

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-18

  • Closed date

    2009-09-28

  • Last modified date

    2009-12-15

  • 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

[{"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.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 December 2009