IBM Support

JR30322: WHEN IMPORTING AN INTEGER FIELD, NON-NUMERIC CHARACTERS DO NOT CAUSE A FORMAT ERROR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When importing
    an
    integer field, the parsing stops at the first non-integer
    character and
    ignores any remaining characters until the next field delimiter.
    This results in the tool silently throwing away data. That is
    unacceptable. The row should be rejected.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users of the Sequential File Stage will not see rejected
    recordsif integer fields contain non-numeric characters.
    ****************************************************************
    PROBLEM DESCRIPTION:
    If users are using the Sequential File Stage to import integer
    fields and those fields contain non-numeric characters only the
    numeric piece of the field will be imported.  The record will
    beimported successfully.
    ****************************************************************
    RECOMMENDATION:
    Apply patch JR30333 and set APT_IMPORT_REJECT_INVALID_CHARS
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • Added an option to allow the user to reject records with
    numericfields that contain non-numeric characters.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30322

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-08-25

  • Closed date

    2008-10-23

  • Last modified date

    2009-12-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • SERVER
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

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

Document Information

Modified date:
17 December 2009