IBM Support

IT04832: SQL QUERY DATA TO DELIMITED DATA TRANSLATION MAP GIVING IMPROPER RESULT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • In a translation map where the input is an SQL
    query and the output is Variable length delimited data. The map
    reads a particular column from a table and maps it to
    a field. The table definition is NUMBER(17,5). 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. The Output
    is also Real 17.
    
    
    After translation, the result is 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
    
    Version Details
    
    Version: 5020402_2
    Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
    Windows Server 2008 R2 6.1 build 7600,amd64
    

Local fix

Problem summary

  • Users Affected:
    All standards enveloping, translation and mapping users
    
    Problem Description:
    SQL query data to Delimited data Translation Map giving
    improper result.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    
    Delivered In:
    5020601_2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT04832

  • 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-10-13

  • Closed date

    2015-10-02

  • Last modified date

    2016-04-18

  • 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":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
18 April 2016