IBM Support

IT05770: TRANSLATION BETWEEN SQL QUERY/FLAT FILE DATA TO SQL INSERT GIVES WRONG RESULT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer has a translation map where the input is a SQL
    query/Flat file  and the output is SQL Insert. The map basically
    reads a particular column from a table/flat file and maps it to
    a field in another database table. Both the table column
    definition is NUMBER. The data is as follows:
    
    10000000000.99999, 20000000000.99999, 30000000000.99999,
    40000000000.99999, 50000000000.99999, 60000000000.99999,
    70000000000.99999, 80000000000.99999,
    90000000000.99999, 100000000000.99999, 200000000000.99999,
    300000000000.99999, 400000000000.99999, 500000000000.99999,
    600000000000.99999, 700000000000.99999, 800000000000.99999,
    900000000000.99999
    
    So in the Map Editor, it takes the format as Real 17 or 32. The
    Output is also Real 17 or 32.
    
    After translation, the result in the table after insert is seen
    as follows:
    
    10000000000.99999, 20000000000.99999, 30000000000.99999,
    40000000000.99999, 50000000000.99999, 60000000000.99999,
    70000000000.99998, 80000000000.99998, 90000000000.99998,
    100000000000.99998
    200000000001, 300000000001, 400000000001, 500000000001,
    600000000001, 700000000001, 800000000001, 900000000001
    

Local fix

  • No Workaround available
    

Problem summary

  • Users Affected:
    All standards enveloping, translation and
    mapping users
    
    Problem Description:
    Translation between SQL query/Flat file data to SQL insert gives
    wrong result.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix has been provided.
    
    Delivered In:
    5020600
    5020500_12
    5020601_7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT05770

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    524

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-12-02

  • Closed date

    2015-10-02

  • Last modified date

    2017-03-08

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

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

Modules/Macros

  • TRANSLAT
    

Fix information

  • Fixed component name

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

  • R526 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
08 March 2017