Direct links to fixes
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
11 September 2023