A fix is available
APAR status
Closed as program error.
Error description
Stored Procedure truncates integer values after 8 digits. The output for an integer value "2147483647" used to be "21474836". Now the output will be "2147483647
Local fix
Changing the field to bigint or char allows the data to be processed correctly
Problem summary
Stored Procedure stage truncates integer data to 8 digits. The issue is present while connecting to DB2 and ODBC. Other Connectivity methods like Oracle, Sybase and teradata do not have this problem.
Problem conclusion
STP now transfers the maximum possible values of integer connecting to all databases not only DB2.
Temporary fix
No temporary fix available.
Comments
APAR Information
APAR number
JR38576
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-29
Closed date
2011-05-25
Last modified date
2011-11-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021