IBM Support

JR33436: MAINTAIN LOW VALUES CONTAINED IN CHARACTER DATA AND DO NOT TRUNCATE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Teradata Load stage is processing character data that
    contains low value characters incorrectly.  Once the low values
    are ecountered, the parser sees this as end of data and
    truncates remaining characters.
    

Local fix

  • To designate the character field as binary so no conversion of
    data takes place.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users having NULLs in the middle of string-data.
    ****************************************************************
    PROBLEM DESCRIPTION:
    This is a special case from AA. User has NULL characters in the
    middle of string-data (This is actually EBCDIC data converted to
    ASCII by PXEngine), which is getting truncated at the occurance
    of first NULL.
    ****************************************************************
    RECOMMENDATION:
    Install the patch
    ****************************************************************
    

Problem conclusion

  • Issued fixed in DSCAPI/OP layer & patch provided.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33436

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    752

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-22

  • Closed date

    2009-07-08

  • Last modified date

    2009-07-08

  • 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

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

Document Information

Modified date:
08 July 2009