Direct links to fixes
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