IBM Support

JR34496: Oracle EE stage bulk loading some numbers as NULLs. Regression f rom JR33242.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • From source file, we are generating Dataset and from Dataset to
    target
    table. Some of the records getting dropped while reading from
    Dataset.
    Appears Dataset is generating control/unknown character into
    dataset
    and not able to load into target (oracle) table.
    

Local fix

  • This fix is included in 8.0.1 fixpack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All.
    ****************************************************************
    PROBLEM DESCRIPTION:
    Some numeric fields are loaded erroneously as NULL.
    Numeric fields whose precision is an odd number load as NULL
    when the value happens to leading two digits as 20.
    Work around is to increase the precision of the effected field
    if you know which.
    Applying this patch is highly recommended.
    ****************************************************************
    RECOMMENDATION:
    apply provided patch.
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • There is a problem with the NULLIF clause encoding for decimal
    loader type fields in the loader control file.
    The problematic  NULLIF clause encoding stands now corrected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34496

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    802

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-08

  • Closed date

    2009-10-15

  • 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

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

Document Information

Modified date:
09 December 2010